Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |