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

[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.

 

[Mike H]

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.

 

[DigESource]

Thank you very much Mike. You have relieved my headache from this. Better
than prescription medication.

Darin

 

[Mike H]

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.

 

[Hans Terkelsen]

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.

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.