Revision history [back]

You can use the SUMIFS function in Excel 2007 to add the values of several columns from a named range. Here are the steps:

1. Create a named range that includes all the columns you want to add. You can do this by selecting the columns, clicking on the "Name Box" at the top of the worksheet, and typing a name for the range.

2. In an empty cell, enter the SUMIFS formula. The syntax is:

=SUMIFS(sumrange, criteriarange1, criteria1, [criteria_range2, criteria2], ...)

Replace "sum_range" with the named range you created in step 1.

1. For each criteria range and criteria, specify the column and the condition. For example, to add the values in columns A, B, and C where column A contains "apples", column B contains "oranges", and column C contains "bananas", the formula would be:

=SUMIFS(my_range, A:A, "apples", B:B, "oranges", C:C, "bananas")

1. Press Enter to calculate the result.

Note that the SUMIFS function can handle up to 127 criteria ranges and criteria pairs.