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.)
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:
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 (for a bit of fun!)
These work because the SUM function ignores non-numeric fields