RE - Criterion is a range | Message 2 of 2 | TechRepublic

Discussion on:

Sum only negative values in a given range using SUMIF()

View entire thread

Message 2 of 2

« Prev

0 Votes

+ -

RE - Criterion is a range

I tried this using a nested and statement and it worked. For example =sumif(Range, and("criteria 1","criteria 2"))

Posted by wehmeier

Updated - 25th Jul