SUMIF function is used to get the “total sum” of values for matching criteria across range.
SUMIF Function has two required arguments i.e. range, criteria and optional argument i.e. [sum_range].
Kindly note, [sum_range] is optional ONLY in-case where criteria and [sum_range] are in ONE column, but if, criteria and [sum_range] are in DIFFERENT columns then [sum_range] is NOT optional
=SUMIF(range, criteria, [sum_range])
range argument is used to give the range of cells in which criteria needs to find,
criteria argument is used to give criteria for sum. We can give value (example “A”,”A*” >10, 50 ) or cell reference# (example: E2) in this argument,
sum_range argument is used to give cell range; those are to be added together as per the criteria mentioned above
We will be using SUMIF function as follows:
– Criteria argument can also work with Wild characters i.e. asterisk (*), question mark (?). Asterisk will find any series of characters and Question mark will find a single character.
– If you want to search actual * or ? (Asterisk or Question Mark) then type tilde (~) before * or ?
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments
SUBSTITUTE function is used to substitute the existing old text to new text.
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
VBA Code to Count Color Cells With Conditional Formatting Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then…