Excel Magic Trick 1459

Adding Food or Accessory Costs For Each Dog with SUMIFS & SUMPRODUCT


Learn how to create use SUMIFS and SUMPRODUCT functions to add the costs for each dog based on whether the expense is for Food or it is an Accessory. This video shows how to use SUMIFS to add with with one condition or another condition, using a function argument array operation to run an OR Logical Test for a sum total.


Download “Excel Magic Trick 1455-1460” Excel-Magic-Trick-1455-1460.zip – Downloaded 100 times – 5 MB

Be the first to comment

Leave a Reply