Microsoft KB Archive/50864

SUM Functions to Sum a Row or a Column Based on a Cell PSS ID Number: Q50864 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x | 2.20

WINDOWS | OS/2

Summary:

Below are two functions that sum down a column or across a row for a certain number of cells.

To sum down column A, starting at row 1, use the following:

=SUM(INDIRECT(“R1C1:R”&End_Row&“C1”,FALSE))

To sum across row 8, starting at column A, use the following:

=SUM(INDIRECT(“R1C1:R1C”&End_Column,FALSE))

Reference(s):

“Microsoft Excel Function Reference,” version 3.0, page 29

Additional reference words: 2.0 2.00 2.01 2.1 2.10 3.0 3.00

Copyright Microsoft Corporation 1993.