row addition
 

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.

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.

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.


On Thu, 17 Mar 2005 06:35:05 -0800, Threshold
wrote:

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.

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)


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