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???
|