How do I total multiple columns in one cell?

[drumz]

I get #VALUE trying:

=SUM(C2:C100)+(D2:D100)+(E2:E100)

and

=SUM(C2:C100+D2:D100+E2:E100)

Can someone give me the correct syntax? It would also be cool to not have to give it an ending cell in the range from row 2 because it could be 80, 100, 150, 200 and the like.

Thanks very much for your assistance!

 

[mikerickson]

You might be looking for =SUM(C2:C100,D2:D100,E2:E100) or =SUM(C2:E100)

To add all rows below and including row 2:
=SUM(C:E)-SUM(C1:E1)

 

[drumz]

Ahh, simple is always best. I like the logic for including all too and again, simple and sweet.

My Sister-in-law and Nephew were Aggie's, and I spent many years in Sacraficialmento - met my wife of 30 years there too. We still visit from time to time but I don't miss the hot summers.

Thanks!

 

[mikerickson]

I'd suggest visiting on Mothers Day weekend.

Glad I could help.