Jump to content
[[Template core/front/custom/_customHeader is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

excel sum question


The Irish Doggy
 Share

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
Link to comment
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
Link to comment
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
Link to comment
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:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information