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
In questa pagina del sito puoi guardare il video online CONDITIONAL SUM USING SUMPRODUCT FUNCTION della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Venkata Reddy Excellent 30 aprile 2020, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 223 volte e gli è piaciuto 3 spettatori. Buona visione!
