sumif question

  • Thread starter Thread starter Tom G
  • Start date Start date
T

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
 
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
 
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
 
Your first formula can be written as

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

for your question use

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