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:

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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
 
Upvote 0
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.
 
Upvote 0
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:):):):)
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top