Discussion on:

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

2

Comments

Add Your Opinion

Join the conversation!

Follow via:: RSS; Email Alert

Community Preferences

View:

Please Select

Show:

Please Select

0 Votes

+ -

What if the criterion is a range

Pillalamarri@... 24th Jul

such as sum only the values greater than "a", and less than "b".

0 Votes

+ -

RE - Criterion is a range

wehmeier Updated - 25th Jul

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

Keyboard Shortcuts:: Prev; Next; Toggle

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.

Join Login