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
En esta página del sitio puede ver el video en línea CONDITIONAL SUM USING SUMPRODUCT FUNCTION de Duración hora minuto segunda en buena calidad , que subió el usuario Venkata Reddy Excellent 30 abril 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 223 veces y le gustó 3 a los espectadores. Disfruta viendo!
