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
On this page of the site you can watch the video online CONDITIONAL SUM USING SUMPRODUCT FUNCTION with a duration of hours minute second in good quality, which was uploaded by the user Venkata Reddy Excellent 30 April 2020, share the link with friends and acquaintances, this video has already been watched 223 times on youtube and it was liked by 3 viewers. Enjoy your viewing!
