Sign in to follow this  
The Irish Doggy

excel sum question

Recommended Posts

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 by The Irish Doggy

Share this post


Link to post
Share on other sites

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 by delusions of granduer

Share this post


Link to post
Share on other sites

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 by Big Country

Share this post


Link to post
Share on other sites

Thanks! :wacko:

 

 

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. :tup:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.