CODEWITHSUNDEEP
excelexcel-formula
Higher-Kinded Type
Higher-Kinded Type

Reputation: 2054

Excel: Formula or function to sum up the column values starting from a certain row

Is there a way (formula or function) in Excel (using AB or RC format) to sum the column values from a certain row (say row 5) and beyond?

I am trying to place a totals row (say on row 2) above the header (which is on row 4), and each column in the totals row displays the sum of the respective column - all rows from row 5 (which is after the header).

Your help is appreciated.

Upvotes: 0

Views: 365

Answers (4)

dashnick
dashnick

Reputation: 2080

You can use the offset function for things like this

=SUM(OFFSET(A2,3,0,995))

where the 995 is the number of rows you want to sum. You can use a count() or something instead of hardcoding it.

Upvotes: 0

pawelty
pawelty

Reputation: 1000

Does SUBTOTAL solve your issue?

=SUBTOTAL(9, B5:B1000)

9 code for SUM

B5 is the the first cell after the header

Upvotes: 1

user4039065
user4039065

Reputation:

It's unclear why a simple SUM function won't work here. If you want to be fancy, try something like the following.

=sum(a5:index(a:a, match(1e99, a:a)))

Fill right as necessary.

Upvotes: 2

Tal J. Levy
Tal J. Levy

Reputation: 598

Assuming I understand your question, so why don't you just write (in location X2, i.e. column X row 2)

=SUM(X5:X25)

Which will give you the sum of column X rows 5 to 25

Upvotes: 1

Related Questions