Paste value from Formula =SUM...

(0) Share

Report

Posted on by Sormick

566

Hello,

Ha have this formula below

=SUM($D$5:$D$10000)

Which gives me the Sum of weights like this:

0.52

1.25

23.52

Can we convert this formula to Value format weight 00.00 ?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

eetuRobo 4,583 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

So do you mean that you want all those to be like:
00.52
01.25
23.52
Then you can just use Text() -function.
Text(=yourVariable, "00.00")

Was this reply helpful? Yes No
Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!

@eetuRobo
No sorry not exactly like that.
I need to get the total of all weights like this in format number 00:00
The weights on my column are already in this format. Just need to convert my sum formula in format number 00:00, not in formula.

Was this reply helpful? Yes No
Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!

Please find a screenshot of my formula:
I dont want it to be this formula: =SOMME($D$5:$D$10000) . I need to be converted to be the value 45.05

Was this reply helpful? Yes No
eetuRobo 4,583 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh okay so you need the sum total of those numbers to be formatted so that the separator is colon :
This is how I got it to work:

Since power fx is in preview there are some bugs. It for what ever reason is not able to convert it straight up like this: =Text(Sum(sum1, sum2, sum3), "00:00")

It can format with the text function like so: =Text(Sum(sum1, sum2, sum3), "00:")
But not if the formatting has colon and numbers after that like ":00"
So thats why you have to split the numbers and add them together again with colon as separator.
Split the sum of the numbers with . as separator. and take the Last item of it.
=Last(Split(Text(SumNumbers), "."))
returns:
Then format the sum with formatting "00:" and add the SumLast.Value
=Text(Sum(sum1, sum2, sum3), "00:" & SumLast.Value)
returns:

Was this reply helpful? Yes No
Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!

@eetuRobo
Thanks for your reply. Is there another way to simplify the conversion of this formula?
Sometimes i have more than 100 weight values so if i add sum1, sum2, sum3 until sum100, this way too long.

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,583 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

You can just use Read from Excel worksheet and read from the cell that has the total weights. Then it should store the total weight into ExcelData variable and use that instead of sum1, sum2, sum3 etc. Those were just examples.

Test excel I created where it read the G3 cell value:

Was this reply helpful? Yes No