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