Sum Function

M

Mike B

I want to add the contentens diplayed in a number of cells whick also contain
formulas. If I use the Sum funcion the result is '0' if I use the count
funtion all the cells are counted. How can I overcome this probles.

Thanks

Mike4
 
M

Mike H

Hi,

=SUM(B1:B6)
If a sum formula like the above returns 0 then the chances are it's trying
to sum text

If you have one of your numbers you are trying to sum in (say) B1 try this
=ISNUMBER(B1)
If it's really a number it will return TRUE or FALSE for text

May be you could post your sum formula or the formula you are trying to sum
the result of.

Mike
 
M

Mike B

Mike H said:
Hi,

=SUM(B1:B6)
If a sum formula like the above returns 0 then the chances are it's trying
to sum text

If you have one of your numbers you are trying to sum in (say) B1 try this
=ISNUMBER(B1)
If it's really a number it will return TRUE or FALSE for text

May be you could post your sum formula or the formula you are trying to sum
the result of.

Mike
Click to expand...

Thanks
Problem sorted
 
Top