sumif question

[Tom G]

How can I modify this:

=sumif(school,"<>"&10,AD)

to be able to do that:

sumif school is not equal to 10 and hs_type is equal to 1.

Thanks

 

[JulieD]

Hi Tom

i would use

=SUMPRODUCT((School<>10)*(HS_Type=1)*Value)

where value is the range that you want to sum as i'm not sure what the AD
referred to in your sumif statement.

Cheers
JulieD

 

[Frank Kabel]

Hi Tom
for this you need SUMPRODUCt: e.g.
=SUMPRODUCT((school<>10)*(hs_type=1),AD)

where school, hs_type and AD are named ranges with the same dimensions

 

[Peo Sjoblom]

Your first formula can be written as

=SUMIF(school,"<>10",AD)

for your question use

=SUMPRODUCT(--(school<>10),--(hs_type=1),AD)