asked on

Counting cells against conditions in 2 columns

I run Excel 2002 in Windows 7.
I have a sheet which grades many examples of 3 items (called A B and C, say) into 3 grades (1, 2, and 3). Each example gets a new row.
Col A contains the Item name, Cols B-H contain other data, Cols I-O contain tests and Col P contains the calculated grade for that example.
I need to count how many examples of Item A in Col A are graded as a 3 in Col P, etc.
Could someone guide me?
Thanks in advance
Tony

Eric Zwiekhorst

sear AWS,

you could use a sumproduct for this.. I will give you the correct formula when you can give me a example.
I run dutch version so paste the formula will not work ...

Kr

Eric

jppinto

Could you post a sample data please? It's not clear what you want to do...

jppinto

jppinto

If you just want to count the number 3 in column A, you can use a simple COUNTIF():

=COUNTIF(A:A,3)

If you want to count using multiple criterias, you need to use SUMPRODUCT() function, like this example:

http://excel-user.blogspot.com/2009/10/sumproduct-sum-values-based-on.html

If you post a sample data, I can give you a more realistic answer.

jppinto

ASKER CERTIFIED SOLUTION

jppinto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

barry houdini

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aws148

ASKER

Thanks very much. Exactly what was needed. And thanks in particular for reference to the simple article on the use of SUMPRODUCT which, for me anyway, has always been the hardest function to understand.
regards
Tony