Returning an answer in an if fuction between two values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up multiple criteria and returning a matching column 2
sum if with an and 2
Which fuction! 2
SUMIF returns no value 2
Count if >0 and between dates 14
SUMPRODUCT returns !Value# 5
Sumproduct is returning irregular values 11
Returning 1 of 4 values if conditions are met 4

Back
Top