Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with multiple constraints
trying to sum a column ignoring two parameters, only successfully ignoring one.
currently using =SUMIF(F:F,"<-420") also want it to ignore values of -560 when returning sum. any help appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with multiple constraints
Try this:
=SUMIF(F:F,"<-420")-SUMIF(F:F,-560) Hope this helps. Pete On Nov 15, 11:46 pm, Jessica wrote: trying to sum a column ignoring two parameters, only successfully ignoring one. currently using =SUMIF(F:F,"<-420") also want it to ignore values of -560 when returning sum. any help appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with multiple constraints
perfect :) thanks for the quick help
"Pete_UK" wrote: Try this: =SUMIF(F:F,"<-420")-SUMIF(F:F,-560) Hope this helps. Pete On Nov 15, 11:46 pm, Jessica wrote: trying to sum a column ignoring two parameters, only successfully ignoring one. currently using =SUMIF(F:F,"<-420") also want it to ignore values of -560 when returning sum. any help appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with multiple constraints
You're welcome - thanks for feeding back.
Pete On Nov 16, 12:01 am, Jessica wrote: perfect :) thanks for the quick help "Pete_UK" wrote: Try this: =SUMIF(F:F,"<-420")-SUMIF(F:F,-560) Hope this helps. Pete On Nov 15, 11:46 pm, Jessica wrote: trying to sum a column ignoring two parameters, only successfully ignoring one. currently using =SUMIF(F:F,"<-420") also want it to ignore values of -560 when returning sum. any help appreciated.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with multiple constraints
Hi,
got the same problem, I want to sum all data under columns in the header row saying 2 OR 4 OR 5 etc. I tried something like: Sumif(lookuprange,OR(2,4,5,etc),sumrange), but it does not work. I obviously could use: Sumif(lookuprange,2,sumrange) + Sumif(lookuprange,4,sumrange) + etc But this is quite inelegant, since I must sum over 7 criteria.... Any suggestions?! "Pete_UK" wrote: You're welcome - thanks for feeding back. Pete On Nov 16, 12:01 am, Jessica wrote: perfect :) thanks for the quick help "Pete_UK" wrote: Try this: =SUMIF(F:F,"<-420")-SUMIF(F:F,-560) Hope this helps. Pete On Nov 15, 11:46 pm, Jessica wrote: trying to sum a column ignoring two parameters, only successfully ignoring one. currently using =SUMIF(F:F,"<-420") also want it to ignore values of -560 when returning sum. any help appreciated.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver Constraints | Excel Discussion (Misc queries) | |||
constraints | Excel Worksheet Functions | |||
macro for 4 constraints in autofilter | Excel Discussion (Misc queries) | |||
Editing a chart with constraints | Charts and Charting in Excel | |||
Solver Constraints | Excel Discussion (Misc queries) |