Counting cells against conditions in 2 columns
Posted on 2011-02-17
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