One way

=SUMPRODUCT(--(E1:E6))

--

HTH

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


"Threshold" wrote in message
...
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.