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
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext