The Irish Doggy Posted February 8, 2011 Share Posted February 8, 2011 (edited) Is there an easy way to sum every other cell into a formula? For example, in a row column of numbers, I want to sum cell 1,3,5,7,9, etc. I'd rather not have to individually make the formula "= a1 +a3 +a5 +a7 ... etc" Edited February 8, 2011 by The Irish Doggy Quote Link to comment Share on other sites More sharing options...
delusions of grandeur Posted February 8, 2011 Share Posted February 8, 2011 (edited) Only way I know how to is after you type SUM=(, and then hold down CTRL as you click to select the cells. This is also how you can selectively choose multiple files in Windows and some other programs too. (ETA: I know that's not a huge help, but definitely easier than typing them all out.) Edited February 8, 2011 by delusions of granduer Quote Link to comment Share on other sites More sharing options...
Big Country Posted February 8, 2011 Share Posted February 8, 2011 (edited) This site has a few options. If you know for sure none of the options have text, you could use their 2nd choice: =SUMPRODUCT((MOD(ROW($A$1:$A$500),2)=0)*($A$1:$A$500)) but as they note, you'll get an error if any of the cells are text. Just adjust the range to suit your needs. Edited February 8, 2011 by Big Country Quote Link to comment Share on other sites More sharing options...
The Irish Doggy Posted February 8, 2011 Author Share Posted February 8, 2011 Thanks! While I was waiting for the Huddle gurus, I found a similar answer. =SUMPRODUCT((MOD(ROW(A1:A250)-ROW(A1),2)=0)*(A1:A250)) Works like a charm. You can substitute the column function instead of row going the other way too. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.