Returning an answer in an if fuction between two values

N

Nat

I am trying to write a SUMIF equation that will return a value between two
values (eg) >15000 but <24999, and I don't know what command to use for the
BUT. Can anyone help?
 
D

Duke Carey

two ways:

=SUMIF(range,"<24999",range)-SUMIF(range,"<=15000",range)
which sums all the values less than 24999 and subtracts the sum of values
less than 15000

=SUMPRODUCT(--(range>15000),--(range<24999),range)
 
Top