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
Auf dieser Seite können Sie das Online-Video CONDITIONAL SUM USING SUMPRODUCT FUNCTION mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Venkata Reddy Excellent 30 April 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 223 Mal angesehen und es wurde von 3 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
