COUNT IF

R

readystate

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

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNT rows on external sheet if between date range 3
Formula to count data in a column that falls between a range 3
Count Distinct Values based on criteria 4
count if 1
COUNT A CORRESPONDING CELL IF A CONDITION IS MET 4
countif two conditions met 2
Count IF Formula 5
How do I count only if either/ or exist 5

Top