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!
How to use the compound interest formula in Excel and gives examples of how to calculate the future value of an investment with yearly, monthly, or daily interest. It also shows you step-by-step how to make your own Excel compound interest calculator.
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
Calculations With Date In Excel Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are…
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.
Watch: How to use VLOOKUP Function in Excel? What is VLOOKUP Function? The VLOOKUP function in Excel searches for a value in a table and returns a corresponding value from another column in the same row…