COUNT IF
 

I am trying to count values based on 3 sets of criteria. In this case, I am
trying to count the number of times the value in column A exceeds 1,000 but
only when column B = Central Region and column C = Group A.

Any suggestions???

COUNT IF
 

if you have Excel 2007 then put this in the cell (except in cols A to C) you
want the result to be;
=SUMPRODUCT(--((A:A)1000),--((B:B)="Central Region"),--((C:C)="Group A"))

and press enter while holding down ctrl and shift keys

"readystate" wrote:

I am trying to count values based on 3 sets of criteria. In this case, I am
trying to count the number of times the value in column A exceeds 1,000 but
only when column B = Central Region and column C = Group A.

Any suggestions???