Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding only NONBLANK cells
I need to add several rows of numbers, say A1:A10 and B1:B10, etc... I need
it to add all NONBLANK cells and display the result in cell A11, B11, etc...- including those that have a zero in a cell rather than just a blank cell. The trouble I am having is in those rows that have all BLANK cells, still shows the sum of that row as zero, when actually it should be blank as there are no entries. In the rows where there are no numbers higher than a zero, but there is at least one zero, the sum of that row SHOULD show zero. Any ideas?? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tally of nonblank cells | Excel Worksheet Functions | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
counting nonblank cells | Excel Worksheet Functions | |||
Excel cannot shift nonblank cells | Excel Discussion (Misc queries) | |||
Adding NonBlank Cells | Excel Worksheet Functions |