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.

[OzduSoleilDATA]

Beautiful. I didn't know SUMIFS worked that way. And once again, SUMPRODUCT to the rescue.

[m.g]

I love excel, since I see how you explain everything so smoothly I follow your videos, got the bell when you post new videos, never commented one.But Thank You!!!! for posting you are really are really great .. Thank you again. .

[pmsocho]

CSE formulas to the rescue! Thanks for the video!

[bagnon]

I use Ctrl + D to copy the row(s) above. It also works great to duplicate objects without having to copy and paste.

[rai_nav]

I have seen loads of your videos but I just learned today why you always use CTRL+enter 😀

[entertainmentgalaxy]

thanks for sharing mixture of two functions.... please share PQ videos

GBU

[Sal_A]

Another important piece is if you want the two criteria's directly in the formula then you would substitute it with this {"Food";"Accessories"}

[ahmedraza]

I have a problem and needs to get solution. for example in a huge sales data
A column = Customer name
B column = Item
C column = Sale Quantity

In column D = I create Unique Item List from column B
And now I wants to know the name of buyer who purchase maximum quantity of each item.

[gwynbrensel]

can help me how to less example 1box=48pcs and i have 10box... what if i less 50pcs... can you help me with the formula?

[SantoshLoka]

i made a 1 program i need a good protection for my program any one can help me out

[henryg]

Video interesting, but Ctrl' or CtrlD 5*