row addition

[Threshold]

How do I make a row add together when one cell has a text function? The
funstion in the one is =TEXT(E6-E5,"h:mm"), I am using it to add up hours
worked then I want to add plan numbers in row to give me a total.

 

[Bob Phillips]

One way

=SUMPRODUCT(--(E1:E6))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Myrna Larson]

Don't use the TEXT formula in the first place. Use just E6-E5 and apply the
h:mm format to the cell. You'll save yourself a lot of hassles this way.

 

[Bob Phillips]

Re-reading this, it probably doesn't make a lot of sense to you. What I am
suggesting is that the range that your formula is in is plugged into the
SUMPRODUCT formula I gave you.

--

HTH

RP
(remove nothere from the email address if mailing direct)