Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Using Multiple Columns
In my worksheet, column B contains text and column J contains either 0,1 or
blank. I am trying to count the rows where the text in column B is a specifc value AND column J is a 0 or a 1 not a blank. I have tried the following: =SUMPRODUCT(--(B2:B333="Housewares"),--(J2:J333=0)) but this is counting the blanks as well. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count if multiple statements in two columns | Excel Worksheet Functions | |||
Sum/Count Multiple columns | Excel Discussion (Misc queries) | |||
Count if Multiple columns | Excel Worksheet Functions | |||
how to count one value or another across multiple columns? | Excel Discussion (Misc queries) | |||
Count on multiple columns | Excel Worksheet Functions |