Hi,

So, names in column A and test scores in columns B,C & D. We can ignore
column A because from you question you only want to know how many not who. So
for 15 in test A & B

=SUMPRODUCT((B2:B2515)*(C2:C2515))

and for 15 in all 3 tests

=SUMPRODUCT((B2:B2515)*(C2:C2515)*(D2:D2515))

Change the ranges to suit.


Mike

"Mrs T." wrote:

Please can anyone help - I am trying to set up a sheet for test scores. I
have a column for the name, a column for test A, a column for test B and a
column for test C results. How can I count how many people have scored over
15 in both tests A and B and how many people have scored over 15 in all three
tests? I am using Excel 2003. I got some help from Pete last night but didn't
get it sorted, I think because I am using a look up table (see thread below)
- 3:00 in the morning is maybe not the best time!
Thanks
Mrs T