| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting occurance of 0 in two columns
Assuming the numbers are *always* positive...
=SUMPRODUCT(--(A1:A70),--(B1:B70)) -- Biff Microsoft Excel MVP "cbrown" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting occurance of 0 in two columns
Thanks, it works! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting occurance of 0 in two columns
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "cbrown" wrote in message ... Thanks, it works! |
| Reply |
| 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 | |||
Linear Mode
