Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif(and
I want to count cells in Column C when column A criteria are met and Column B
criteria are met. ex. Countif(AND(A1:A5,M3,B1:B5,M4,COUNT(C1:C5) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif(and
=SUMPRODUCT(--(A1:A5=M3),--(B1:B5=M4),--(C1:C5<""))
-- David Biddulph "John" wrote in message ... I want to count cells in Column C when column A criteria are met and Column B criteria are met. ex. Countif(AND(A1:A5,M3,B1:B5,M4,COUNT(C1:C5) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif(and
John,
It's not entirely clear what you mean by 'count' column C, do you mean any value? Here's a couple of ideas Number in A&B anything in C =SUMPRODUCT((A1:A10=123)*(B1:B10=234)*(C1:C10<"") ) Text in A&B anything in C =SUMPRODUCT((A1:A10="ABC")*(B1:B10="DEF")*(C1:C10< "")) Sum column C =SUMPRODUCT((A1:A10="ABC")*(B1:B10="DEF")*(C1:C10) ) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "John" wrote: I want to count cells in Column C when column A criteria are met and Column B criteria are met. ex. Countif(AND(A1:A5,M3,B1:B5,M4,COUNT(C1:C5) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |