Excel Magic Trick 1459

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

DESCRIPTION

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.

WORKBOOKS

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







Be the first to comment

Leave a Reply