SUMIF with Mulitple Conditions

[Guest]

Is it possible to use SUMIF (or something like it) with mutiple conditions?

So for example: SUMIF(A1,A100,"<=100",B1,B10) will give me everything <= to
100. But what if I only want to check for values that are >= 50 and <= 100?

Can I use a range of somekind to do this?

Thanks

 

[Chip Pearson]

Use the following SUMPRODUCT formula:

=SUMPRODUCT(--(A1:A100<=100),--(A1:A100>=50),B1:B100)

 

[Bob Phillips]

=SUMIF(A1,A100,">=50",B1,B10)-SUMIF(A1,A100,">100",B1,B10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)