| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SumIf Function using multiple criteria
I am trying to sum the amounts in column A based on the figure in Column B.
I want the formula to sum Column A if the value in Column B is between 99 and 200. For some reason, I am having trouble with the multiple criteria part of this. Is there a way to do this, another function, or anything? |
|
#2
|
|||
|
|||
|
Either
=SUMIF(B1:B500,"=99",A1:A500)-SUMIF(B1:B500,"200",A1:A500) or =SUMPRODUCT(--(B1:B500=99),--(B1:B500<=200),A1:A500) -- Regards, Peo Sjoblom "Jamie A Miller" (donotspam) wrote in message ... I am trying to sum the amounts in column A based on the figure in Column B. I want the formula to sum Column A if the value in Column B is between 99 and 200. For some reason, I am having trouble with the multiple criteria part of this. Is there a way to do this, another function, or anything? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions | |||
| sumif with multiple criteria | Excel Worksheet Functions | |||
| How do I sum (like sumif) but predicated on multiple criteria, in. | Excel Worksheet Functions | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Linear Mode
