Try this for your first query:

=SUMPRODUCT((A1:A100=15)*(B1:B100=15))

and this for your second:

=SUMPRODUCT((A1:A100=15)*(B1:B100=15)*(C1:C100= 15))

assuming scores for test A are in column A etc. Adjust the ranges to
suit your data.

Hope this helps.

Pete

On May 2, 1:31*am, Mrs T. <Mrs wrote:
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..
Thanks