![]() Now, let's look at the example =SUMIF(A2:A6, D2, C2:C6) that returns a value of 218.6 and take a closer look why. Result: 31.2 'Adds values in C2:C6 that are less than 100 (3rd parameter is omitted) Result: 12.6 'Criteria is greater than or equal to 2001 Result: 218.6 'Criteria applies to all of column A (ie: A:A) Result: 218.6 'Criteria is the value in cell D2 ![]() Let's explore how to use SUMIF as a worksheet function in Microsoft Excel.īased on the Excel spreadsheet above, the following SUMIF examples would return: =SUMIF(A2:A6, D2, C2:C6)
0 Comments
Leave a Reply. |