CONDITIONAL SUM USING SUMPRODUCT FUNCTION
How to get conditional sum using SUMPRODUCT function
SYNTAX
=SUMPRODUCT(array1, [array2], [array3], ...)
Array1 - Mandatory
Array2, 3, ... - Optional
-----------------------------------------------------------------------------
The array arguments must have the same dimensions. If they do not, SUMPRODUCT returns the #VALUE! error value. For example, =SUMPRODUCT(C2:C10,D2:D5) will return an error since the ranges aren't the same size.
SUMPRODUCT treats non-numeric array entries as if they were zeros.
It is important to understand how to put brackets "()" correctly in SUMPRODUCT function.
-----------------------------------------------------------------------------
I have begun the video explaining the basic use of sumproduct to get the sum of the product of two ranges followed by few of the complex operations using this function.
We can use sumproduct as an alternative to other functions like SUM, COUNTA, COUNTIF(S), SUMIF(S) etc.
You will also learn, how to apply multiple criteria in columns and rows to get the conditional sum or count. Both AND and OR conditions are explained in detail.
While using SUMPRODUCT as array function, there is no need to press CSE (Ctrl + Shift + Enter). Have shown an example by calculating the total number of characters in a range (multiple cells)
-----------------------------------------------------------------------------
Thank you for watching this video. Please provide your feedback / queries in the comment section below.
Download the Demo Excel file used in this video here:
https://drive.google.com/open?id=1eZT...
Do you want more videos like this?
Please support me by subscribing to my YouTube channel.
You can also follow my Instagram page for my videos.
Mail ID: venkatareddyexcellent@gmail.com
Instagram Page: / venkatareddyexcellent
Youtube Channel: / @venkatareddyexcellent
#ConditionalSumUsingSumproductFunction,
#SumproductMultipleCriteriaInSameColumn,
#SumproductMultipleCriteriaInMultipleColumn,
#SumproductMultipleCriteriaArray,
#SumproductFunctionInSubtotal,
#NumberOfCharactersInARange,
#venkatareddyexcellent, #venkatreddyexcellent
Sur cette page du site, vous pouvez voir la vidéo en ligne CONDITIONAL SUM USING SUMPRODUCT FUNCTION durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Venkata Reddy Excellent 30 avril 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 223 fois et il a aimé 3 téléspectateurs. Bon visionnage!
