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

djdave007

New Member
Joined
Sep 17, 2008
Messages
13
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:

Some videos you may like

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
Joined
Feb 22, 2008
Messages
2,276
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
Joined
Apr 4, 2007
Messages
6,934
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
Joined
Sep 17, 2008
Messages
13
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:):):):)
 

Watch MrExcel Video

Forum statistics

Threads
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...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top