Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Just learning about these functions...
Have one column, c4-c34 and when complete it will have cells with numbers and cells left blank. I need totals on both. cells with numbers: =counta(c4:c34) This works, (received the answer from the perusing the disscussion list) cells blank: =countif(c4:c34,0). Does not work unless I put a zero in each blank and then that affects the count of the cells wth numbers in them. How do I count blank cells? c4 to c34 = 31 cells. I haven't found the formula yet. Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) |