# HELP plz?? Trying to count number of occurances in 1 column, that occur between dates in another

#### djdave007

##### New Member
Hi,
I've been struggling to get my head around, what is possibly a simple formula.. heads fried..

Column A Column B

A 03/01/2008
A 15/01/2008
A 29/01/2008
B 31/01/2008
B 23/01/2008
B 12/02/2008
B 08/02/2008
C 20/02/2008
C 15/02/2008

I am trying to find out how I can write a formula that tells me how many times "A" occur IN Column A, AND are within January 08, which is highlighed in Column B, "B" occurs within January 08, "C" occurs within January 08 etc... then replicate for the following months..

Really need help with this...plz

thanks
Dave

Last edited:

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### sous2817

##### Well-known Member
Not sure if this is what you want, but it might be close:
Book1
ABCD
1A1-Jan-2008
2A15-Jan-20083
3A29-Jan-2008
4B31-Jan-2008
5B23-Jan-2008
6B2-Dec-2008
7B8-Feb-2008
8C20-Jan-2008
9C28-Jan-2008
Sheet1

#### schielrn

##### Well-known Member
You could also use this formula confirmed with control+shift+enter and not just enter:

=sum((A1:A10000="A")*(month(B1:B10000)=1))

In pre-2007 you cannot use whole column references and must be the same length. Hope that helps.

#### djdave007

##### New Member
guys,
thank you very much...
they worked a treat... I needed something automated so I could use for charts.
As there are a lot of us using this data, its a great time saver, and don't have to rememeber to refresh like pivot charting.

thanks again
dave

1,102,042
Messages
5,484,348
Members
407,437
Latest member
alfaroM

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...