I want to be able to sum together the values of an entire row except for the first 2 cells. So something like this:
=sum(A3:A*infinity*)
How do I do this?
I want to be able to sum together the values of an entire row except for the first 2 cells. So something like this:
How do I do this? 


Something similar has been asked before and I'll repeat this answer: just put:
because that's the max number of cells per column / row in Office 2007 and 2010. (65536 is max for before 2007.) (For columns, the max column name is XFD in 2007 and 2010, and IV before 2007.) 


I thought you could simply do the following: =SUM(A3:A) 


To sum an entire row:
Replace 1 with your starting row number and then use the autofill handle accordingly. If you drag the formula down, it'll change to "=sum(2:2)" and so on.. To sum the entire row, except the first 2 columns:
This'll help you cut down on the file size. 


Add up everything and then take away the ones you don't want to include:
Edit: As josmh has pointed out, the formula above will fail with an error if A1 or A2 are non numeric  but the following will work:
or
or (for a bit of fun!)
These work because the SUM function ignores nonnumeric fields 

