Sum Function
 

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

Sum Function
 

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
"Mike B" wrote:

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

Sum Function
 

"Mike H" wrote:

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
"Mike B" wrote:

I want to add the contentents 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 problem.

Thanks

Mike

Thanks
Problem sorted