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

[djdave007]

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

 

[sous2817]

Not sure if this is what you want, but it might be close:

Book1
	A	B	C	D
1	A	1-Jan-2008
2	A	15-Jan-2008		3
3	A	29-Jan-2008
4	B	31-Jan-2008
5	B	23-Jan-2008
6	B	2-Dec-2008
7	B	8-Feb-2008
8	C	20-Jan-2008
9	C	28-Jan-2008
Sheet1

 

[schielrn]

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]

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