Re: Adding cells in Excel

Discussion in 'Microsoft Certification' started by Martin Schmid, Jul 30, 2003.

  1. Yes.. you can do something like this:

    (View w/ a constant width font, such as Courier New)



    A B

    1 CellsToSum SumBit

    2 1 1

    3 100 0

    4 2 1

    5 200 0

    6 3 1

    7 300 0

    8 =SUMIF(B2:B7,1,A2:A7)------>6

    9 =SUMIF(B2:B7,0, A2:A7)----->600

    10 =COUNTIF(B2:B7,1, A2:A7)--->3

    11 =COUNTIF(B2:B7,0, A2:A7)--->3

    12 =A8/A10-------------------->2

    13 =A9/A11-------------------->200


    "Jean" <> wrote in message
    news:033601c355fd$b8bda8f0$...
    > Is there a formula to SUM or AVERAGE every OTHER cell in
    > a range? In other words, is there a function that can be
    > used to avoid typing something similar to =sum
    > (a1,a3,a5,a7,a9)?
    Martin Schmid, Jul 30, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ben Lord

    Excel Cells not adding up

    Ben Lord, Oct 15, 2003, in forum: Computer Support
    Replies:
    2
    Views:
    5,226
    Harrison
    Oct 15, 2003
  2. Steve Freides

    How to format Excel cells as email addresses?

    Steve Freides, Sep 21, 2005, in forum: Computer Support
    Replies:
    8
    Views:
    33,709
    powerman1959
    Dec 28, 2010
  3. =?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=

    convert yyyymmdd text cells into date cells

    =?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=, Nov 22, 2006, in forum: Microsoft Certification
    Replies:
    2
    Views:
    3,519
    =?Utf-8?B?ZF9jYW1wZWxvQGhvdG1haWwuY29t?=
    Nov 22, 2006
  4. Richard Miller

    Combinding cells in Excel

    Richard Miller, Apr 11, 2006, in forum: Computer Support
    Replies:
    4
    Views:
    426
  5. Ed
    Replies:
    2
    Views:
    523
    WhzzKdd
    Feb 16, 2007
Loading...

Share This Page