Now, we will discuss a formula that will sum up the values of the cells indicated by blue color. To mark those products, you have attributed them with blue color. The actual cells that are added are determined by using the top, left cell in that criteriarange as the beginning cell, and then including cells that correspond in size and shape to sumrange. Suppose, you want to sum up the total price of the products having MTT in their product ids. Shortcut Tip: If you have multiple columns of data, simply copy the formula to other rows by “locking” your variables and copying the formula across all columns. To demonstate using the formula above, our formula would then become =SUMIF($A$8:$A$22,$A24,D$8:D$22) where the column identifying “Region” (Column $A$) is locked for rows and columns, the Region to sum (Cell $A24) is locked for column, and the units (Column D$) lock the rows, but not the column – so that the formula can be copied to other rows. Use of the SUMIF Function to Sum up Colored Cells in Excel. “Variable” is in cell A24 (you can also replace the A24 with “Asia”, but that requires editing the formula if you want to find the results for “North America” or “Europe”).“Sum_Range” is the number of units in column D.“Variable_Range” is the list of countries in column A. ![]() ![]() ![]() Next, using the data from our example below, let’s say we need to find the sum of units sold in Asian countries. ![]() =SUMIF(Variable_Range,Variable,Sum_Range) Let’s start with the following SUMIF formula:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |