Add columns to a specific cell

[NerdRN]

Ok, so forgive me if this is a common question, but I did do a search and couldn't find this exact need.

1. I have a 2007 excel spreadsheet, and column T is a TOTAL column.

2. What column T totals is always the same for each row. example: T2 is the total for G2:S2. and it moves up 1 respectively with each T cell, so T3 is the total for G3:S3, T4 total for G4:S4, and so on.

Now, I know I can add a simple formula "T3=SUM(G3:S3)" for each line, but, I have over 1000 lines, and they are always adding more contestants (this is a car show spreadsheet that is adding up total points in various categories.

So is there a way to code this so it will automatically do this so when they add more contestants, I don't have to go in and add in a sum formula? you know T1535 will always be the total for G1535:S1535 and so on

I hope I explained this well enough. Any help would be appreciated since this is my fathers retired hobby and he wouldn't have to send it to me to edit every week

Thanks so much!!

 

[VoG]

You can pre-enter this formula

=IF(G3="","",SUM(G3:S3))

and copy down as far as needed. It won't display anything until an entry is made in column G.

 

[NerdRN]

I'm no excel pro, but does your formula assume that there is always something in G?

If so, that won't work, as there may be times where no numbers will be in G

there may a single number, no numbers, or many numbers for each row, cells G-S

The column T just add it anyway...so if there are no numbers, it will show a total of 0

Thanks for the fast reply!!!

 

[VoG]

No it doesn't assume that, in fact the opposite. Try it

 

[NerdRN]

either I have pasted this to the wrong place or it doesn't work...I am certain it is the former, lol

where should I be pasting this formula, exactly ?

Thanks!

 

[VoG]

In T3 presumably, enter the formula and copy down.

 

[NerdRN]

Yes, that's what I thought.

It only works if there is a value in cell G, even a zero is required for it to work.

however, all cells are blank from the start, no numbers at all, and I have a VB code, so they can double click a cell and it will increase that cell by 1.

I guess I will just manually enter in a sum formula for each row. Tedious and boring but do-able

Thank you very very much for your replies!

 

[Nalani]

Enter your Sum formula in T3 hit Enter. Return to T3 and hover over the lower Right Corner of that cell.

When the Pointer turns to a black cross, hold the Left Click button and drag down as far as you want, then let go of the button. Maybe row 2000 since you mention row 1535.

 

[NerdRN]

BLESS YOU MY FRIEND!!!!

That's exactly what I needed! what a neat trick that took 2 seconds!!!

THANK YOU THANK YOU!

Great board with fast, helpful people!

Thanks to you both!!!!

 

[Nalani]

Thanks for the feed back.

Another trick for you:
If you had something in all rows in column S3:S200, for example. And you Double Click the lower right corner of T3, it would have filled your formula even quicker.