How do I do a "between" in an IF statement?

[Guest]

I need to sum a column and the condition has multiple criteria:


SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28)

how do I represent "between 5 and 10"?

 

[Don Guillett]

=sumproduct((g16:g28>=5)*(g16:g28<10)*e16:e28)

 

[Beege]

I need to sum a column and the condition has multiple criteria:

SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28)
how do I represent "between 5 and 10"?

I thin you need an AND(___<10, ___>5) in there

Beege

 

[Bearacade]

Or you can do this..

=SUMIF($G$16:$G$28,">=5")-SUMIF($G$16:$G$28,">10"

 

[joeu2004]

Or you can do this..
=SUMIF($G$16:$G$28,">=5")-SUMIF($G$16:$G$28,">10")

A m-u-c-h more intuitive expression. KISS!

Of course you meant sumif(..., $E$16:$E$28) in both cases; a minor
omission.

 

[Guest]

Thanks, Don! It worked great.

sumproduct? never in a million years would I have figured that out....

 

[Bearacade]

A m-u-c-h more intuitive expression. KISS!

Of course you meant sumif(..., $E$16:$E$28) in both cases; a minor
omission.

Aye yes, hehe. Thanks for catching that mistake =

 

[Don Guillett]

did you test?

 

[Don Guillett]

A m-u-c-h more intuitive expression. KISS!
why do you think that is better than learning to use sumproduct?