Nested SUMIFs??

[AnonyMouse]

Hi all.

I want to average test scores for a particular group of people in our
dataset - those people who have not had a decision/disposition and are part
of a particular group.

In the past, when I wanted to average based on one condition I would use
SUMIF:
SUMIF(Decision,"NULL",Scores)
And then I'd divide the summed scores by the number of people.

How can I do this with two criteria? In effect, something like this (though
I know it's not a valid formula)...
SUMIF((Decision="NULL)*(Round="0"),Scores)

Any help?

Thanks, Mouse

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(Decision = NULL),--(Round=0),Scores)




For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

 

[Don Guillett]

try
=sumproduct((Decision="NULL)*(Round="0")* Scores)