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(--(range15000),--(range<24999),range)

"Nat" wrote:

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?