Excel Magic Trick 1459: Adding Food or Accessory Costs For Each Dog with SUMIFS & SUMPRODUCT

Download Files: http://ift.tt/2xNrzlB
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
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.

View on YouTube