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 day
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 in
Physics.
Just copy it somewhere else and change "Phy" for "Math", and there you
go with the Maths, then copy it somewhere else and change "Math" for
"Chem" and there you have the results for Chemistry.

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

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

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

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


--
Hanzo
------------------------------------------------------------------------
Hanzo's Profile: http://www.excelforum.com/member.php...o&userid=29955
View this thread: http://www.excelforum.com/showthread...hreadid=496327