| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting occurance of 0 in two columns
I have two columns, mostly of zeros, and want to count the number of times
both columns are not zero in the same row. eg 0 5 0 0 1 0 4 2 29 55 0 0 7 4 answer is 3. I have tried =COUNT(IF((R4:R35=0)*(S4:S35=0),R4:R35)), which comes back as zero. other attempted methods give 0 or value errors, or wrong answers. thanks for the help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the Excced occurance... | Excel Discussion (Misc queries) | |||
| Occurance Counting | Excel Worksheet Functions | |||
| Counting occurance of text values across multiple worksheets | Excel Worksheet Functions | |||
| Counting occurance of letters or numbers | Excel Discussion (Misc queries) | |||
| Occurance of data in multiple columns | Excel Worksheet Functions | |||
Threaded Mode
