Results 1 to 6 of 6

Counting Occurrences

This is a discussion on Counting Occurrences within the Excel Questions forums, part of the Question Forums category; Would anyone have a way to do this in one formula, come up with 5 in one formula? Rather the ...

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    890

    Default Counting Occurrences

    Would anyone have a way to do this in one formula, come up with 5 in one formula? Rather the sum the occurrences.

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl2002 XP : OS = Windows XP
    File Edit View Insert Options Tools Data Window Help About
    =

    A
    B
    C
    D
    1
    13005
    2
    2351*
    3
    3401*
    4
    4240*
    5
    5351*
    6
    6260*
    7
    2371*
    8
    3470*
    9
    4341*
    Sheet1*

    [HtmlMaker light Ver1.10] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  2. #2
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,947

    Default

    Here you go:

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl97 : OS = Windows Windows 2000
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    1
    1305*
    2
    235**
    3
    340**
    4
    424**
    5
    535**
    6
    626**
    7
    237**
    8
    347**
    9
    434**
    Sheet2*

    [HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    890

    Default

    Now why didn't I think of that?

  4. #4
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,947

    Default

    Quote Originally Posted by maxflia10
    Now why didn't I think of that? :oops:
    It happens to me ALL the time.
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default

    Or the following array formula ...

    =COUNT(IF(A1:A9>=2,IF(A1:A9<=5,IF(B1:B9>=30,IF(B1:B9<=40,A1:A9)))))
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  6. #6
    Board Regular
    Join Date
    May 2002
    Posts
    890

    Default

    Quote Originally Posted by Yogi Anand
    Or the following array formula ...

    =COUNT(IF(A1:A9>=2,IF(A1:A9<=5,IF(B1:B9>=30,IF(B1:B9<=40,A1:A9)))))
    Thanks Yogi!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com