SUMIFS Function

The SUMIFS function returns the total value of the numbers that satisifes multiple conditions.

This formula automatically replaces the actual condition with an array of corresponding 1's and 0's.
The 1's are used to represent when the condition is True and the 0's are used to represent when the condition is False.



Conditional Sum Wizard

Removed in Excel 2010


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext