Create an Excel spreadsheet containing the three elements necessary to use the SumIf function, range, criteria and sum_range. The range includes the cells that Excel compares to the criteria to determine whether to add the associated sum range values. To illustrate, let's use SumIf to determine the number of babies born at local hospitals in 2006.
Type a range in column A from cells 2 to 50. For this example, the years of the births are the range so type in years ranging from 2000 to 2008 in random order. Also, enter the hospital names in Column B beside the year, even though the hospital name will not be a direct part of the SumIf function.
Enter random number of births in column C for each hospital for the corresponding years. This is the sum_range. Next, enter the criteria, 2006, into column D and row 2.
Put the SumIf statement "=SumIf(A:A50, D2, C2:C50)" in a cell on the spreadsheet. Be sure to begin the formula with an equal sign so Excel recognizes the function formula. Excel should sum or add the number of births corresponding only to the rows with a 2006 as the year. Manually add the births with a calculator to check that your function is correct.
0 comments:
Post a Comment