| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count function
I want to count cells going across but do not want to count that cell if it
is blank or has a 0 Example =count(e4:I4) the answer returns 5 however in cell f there is no data so the answere should be 4. how can i write a formula so if the cell is blank or has 0 it does not count that cell. thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200805/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another which count function? | Excel Worksheet Functions | |||
| COUNT Function | New Users to Excel | |||
| which count function? | Excel Discussion (Misc queries) | |||
| i need help with the "count" function | Excel Worksheet Functions | |||
| Sum and Count Function | Excel Worksheet Functions | |||
Threaded Mode
