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. |
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) |