Excel: How do I reference an entire row except for a couple of cells?
Excel: How do I reference an entire row except for a couple of cells?
Excel: How do I reference an entire row except for a couple of cells?
Re: Excel: How do I reference an entire row except for a couple of cells?
Something similar has been asked before and I'll repeat [this answer](https://superuser.com/questions/88449/selecting-whole-column-except-first-x-header-cells-in-excel/88601#88601): just put:
```
=sum(a3:a1048576)
```
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.)
```
=sum(a3:a1048576)
```
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.)