CODEWITHSUNDEEP
excelsum
Maykid
Maykid

Reputation: 517

Excel SUM of Column

My question is relatively simple I believe, just not getting it just yet. So here is where I am having trouble,

Let's say, Column C has numbers from C3:C33, I have other items underneath C33 but want to have a SUM of C3:C33 in Column J4 as total. That is easy enough, but when I try inserting a line at C33 to add an additional number, it doesn't automatically SUM in the cell J4. I've looked for answers and I've came across this formula:

    =SUM(INDIRECT("C3:C"&ROW()-1))

That works right under C33, and works fine if I have J4 =C33 and just simply hide that formula's row. But I'm wondering is there another Formula that will automatically auto adjust SUM from J4?

Any help would be great!

-Maykid

Upvotes: 0

Views: 152

Answers (2)

Scott Craner
Scott Craner

Reputation: 152660

Use:

=SUM(C3:INDEX(C:C,MATCH("Totals",A:A,0)-1))

Now no matter the number of rows, it will sum only those from C3 to the row above where Totals is found in column A.

Upvotes: 2

Barry Kaye
Barry Kaye

Reputation: 7759

Try to use SUM(C3:C34) and leave C34 blank. You should now be able to insert below C33 and the formula should automatically adjust.

Upvotes: 1

Related Questions