I recently looked at the formula
and thought that it was unreadable. But if you press the fx in the formula bar, ![]() ![]() the Function Arguments dialog pops up. ![]() which makes it easier to understand. This is an example of the =SUMIFS( ) function. Its purpose is to sum data based on multiple conditions. Here is the data and formulas I entered ![]() and here are the results ![]() Older versions of Excel don't support the SUMIFS( ) function so you could do the following
|