# 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. ## 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
 C1D1C2C3C4C5C6C7C8C9 =

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. 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
 C1 =

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.

3. Now why didn't I think of that?

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

5. Or the following array formula ...

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

6. 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!

#### Posting Permissions

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