Using Sumproduct Function In Excel To Subtotal Filtered Data

[@tantungnam]

You give such a thorough and easy understanding video. I love how you explain the function of the dashes as I never understood why they appear in some formula. Thank you and hope you could provide high quality content like this in the future.

[@gleneclarketraining8920]

Thanks for the message and for watching. Am going to try to upload more videos on a regular basis.

[@mcyril4391]

Excellent explanation, really clear. Thank you!

[@vhc6600]

... as you are doing the multiplication on the criteria you don't need the double negative --
=sumproduct((A6:A17=10)*(D6:D17="x")*C6:C17) = 75
without criteria multiplication and double negative to convert the criteria:
=sumproduct(--(A6:A17=10),--(D6:D17="x"),C6:C17) = 75

[@gleneclarketraining8920]

Great feedback. I will give it a try! Thanks for watching!

[@heartcontract]

Thank you!