Glad the explanation was accepted <g> !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

You mention you have different signatures, right?
Well, it sounds like that.
In that case you need to include the Signature...
Probably there is a better way to do it, but I am in the end of my da
and my brain is working over time, so here is an idea:

Assuming your spreadsheet looks like this:

Column A:    Column B:    Column C:

Math           50              John
Phy             70              Marie
Chem          55               Hollie
Math           62              Steve
Math           80              George
Chem          90               Patricia
Phy             55              Robert
Chem          55               Catherine
Phy             85              Ivette
Math           60              Jacob

Add a 1 to every row in column D to look like this:

Column A:    Column B:    Column C:     Column D:

Math           50              John                 1
Phy             70              Marie                1
Chem          55               Hollie                1
Math           62              Steve                1
Math           80              George              1
Chem          90               Patricia             1
Phy             55              Robert              1
Chem          55               Catherine          1
Phy             85              Ivette               1
Math           60              Jacob                1

and then the next code where you want the results:

=SUM(IF(($A$1:$A$10="Phy")*($B$1:$B$10>=50)*($B$1:$B$10<60),$D$28:$D$43))

That should give you the result for all the guys that are >50 <60 i
Physics.
Just copy it somewhere else and change "Phy" for "Math", and there yo
go with the Maths, then copy it somewhere else and change "Math" fo
"Chem" and there you have the results for Chemistry.

The only thing you have to do is to press CTRL+SHIFT+ENTER instead o
only ENTER, either when paste or edit the formula, since it works wit
ARRAYS.

Now, It only depends on how your organization is. If your signature
are in different Worksheets, then you don't need my code.

If everything is together, then you can even modify it to get th
results by Name or whatever.

If it helps, go on, if not, just ignore it! :