| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Returning an answer in an if fuction between two values
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF fuction and format ... | Excel Worksheet Functions | |||
| Excel Answer Wizard BROKEN | Excel Discussion (Misc queries) | |||
| Page Number Fuction | Excel Discussion (Misc queries) | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Hybrid Mode
