SUMIFS Function

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

alt text

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.


alt text

Conditional Sum Wizard

Removed in Excel 2010


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