![]() ![]() For instance, you can re-write the above formula so that it references the cell containing the name of the product to be summed: Instead of text, you can include a number, date or a cell references in your criteria. This formula example demonstrates the simplest usage of the SUMIF function with the text criteria. Putting this together, you get: =SUMIF(A2:A8, "bananas", C2:C8) ![]() Now, let's define the arguments for our SUMIF formula: You want to know the sum of all amounts relating to a given product, e.g. Suppose you have a list of products in column A and corresponding amounts in column C. To illustrate the Excel SUMIF syntax better, let's consider the following example. If the sum_range argument is omitted, Excel will sum the same cells to which the criteria is applied (i.e. This argument is optional, and you need to use it only if you want to sum cells other than defined in the range argument.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |