=SUMIF(A2:A9,5)
The formula above totals up the values from cell A2 to A9 based only on those cells that contain the value of 5. So if only cell A3 =5 and cell A5 = 5 as well and the other cells don't equal 5. Then the total value of the sumif formula would be 10. As the number 5 only appears twice in the cell range.
The formula above totals up the values from cell A2 to A9 based only on those cells that contain the value of 5. So if only cell A3 =5 and cell A5 = 5 as well and the other cells don't equal 5. Then the total value of the sumif formula would be 10. As the number 5 only appears twice in the cell range.
0 comments:
Post a Comment