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!
Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…
Merge Cells in Excel Merge cells is to combine multiple cells into one cell which can further be used for giving title to the report or header to the column. It helps to create clean…
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell