How do I sum cells that have values from a text formula?

  • Thread starter Thread starter DigESource
  • Start date Start date
D

DigESource

How do I sum cells that have values from a text formula?

I have a row of this formula: =TEXT(D6-D5,"h")

The only difference in the cells of the row are the referring cells.

When I sum them up, and just get a 0. So I figure I have to use a formula
that counts the resulting values of other formulas, but I cannot find it in
the help system.

=SUM(B7:H7) <---- results in a 0 no matter what the values of the cells
are.
 
Hi,

Let's say the formula to sum are in a1 & B1, try this

=SUMPRODUCT(A1:B1+0)

Extend the range A1:B1 as required
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Thank you very much Mike. You have relieved my headache from this. Better
than prescription medication.

Darin
 
Glad i could help and thanks for the feedback

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
DigESource said:
How do I sum cells that have values from a text formula?

I have a row of this formula: =TEXT(D6-D5,"h")

The only difference in the cells of the row are the referring cells.

When I sum them up, and just get a 0. So I figure I have to use a formula
that counts the resulting values of other formulas, but I cannot find it in
the help system.

=SUM(B7:H7) <---- results in a 0 no matter what the values of the cells
are.
Click to expand...

Mike's answer is the best,
but it might be fun to try
=IMSUM(B7:H7)
The result will still be text hours.
Hans T.
 
Back
Top