Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf with 2 criteria possible?
Microsoft 2003 - I am trying to do a count of the number of cells that match
my criteria by using the countif command. However, I need it to look at 2 separate criteria items before a match is made. It needs to look in column B:B first to make sure the criteria is there and then needs to look in column C:C to make sure the value for that cell is not equal to 0. If those criteria both match, I want it to bring back the total number of cells this is true for. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf with 2 criteria possible?
try
=sumproduct(--(B1;B100=criteria1),--(C1:C100<0)) the --( changes the logical true false to numeric 1 0 the arrays must be the same size and cannot refer to a full column for pre 2007 "duketter" wrote: Microsoft 2003 - I am trying to do a count of the number of cells that match my criteria by using the countif command. However, I need it to look at 2 separate criteria items before a match is made. It needs to look in column B:B first to make sure the criteria is there and then needs to look in column C:C to make sure the value for that cell is not equal to 0. If those criteria both match, I want it to bring back the total number of cells this is true for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif criteria | Excel Worksheet Functions | |||
Two criteria for CountIf? | Excel Worksheet Functions | |||
Countif With Criteria | Excel Worksheet Functions | |||
Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions |