For instance, instead of “TV” if I change the value as “Mobile”, it will return the total sales of mobile.ģ. If you change the value in the cell reference, Excel will automatically find the value that is specified in the cell reference. Continue with a comma and pass the criteria as an argument to identify which cells to add. ![]() ![]() The criteria must be enclosed in double-quotes ( ” “) for the text strings and the cell references are not enclosed with double quotes ( ” “).Ģ. Select the cell where you want to add the cells and type =SUMIF and pass the range as an argument for the evaluation done by criteria. Now, we have to find total sales of TV by giving a single criterion.ġ. SUMIF function supports only a single criterion.Įxample: Here I have a list of data that contains Month, Salesman, Region, Product, No. This function is applicable for dates, text, and numbers. To define the criteria, this function supports logical operators (,, =) and wildcard characters (*, ?) for partial matching. SUMIF function in Excel returns the addition of cells that meet a specific condition or criteria. ![]() Do you know that you can sum your particular data by specific criteria using the SUMIF function? Want to know that simple formula to add your cells? Then this article will let you know about the SUMIF function in Excel with an appropriate example.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |