Adding up the number of times a month is in a column
 

I have two colums, of which column B has months and dates. Sometimes the
date can be up to three times added, or not at all. I can't figure out a
formula to show me how many times Mar was added (12 in the below case) and
Apr was added (6 in the below case).

Number of update Date
1 1-Mar
2 1-Mar
3 1-Mar
4 2-Mar
5 2-Mar
6 2-Mar
7 3-Mar
8 3-Mar
9 3-Mar
10 4-Mar
11 4-Mar
12 4-Mar
13 1-Apr
14 1-Apr
15 1-Apr
16 2-Apr
17 2-Apr
18 2-Apr

Please help and thanks in advance!

Adding up the number of times a month is in a column
 

One way

=SUMPRODUCT(--(MONTH(A2:A50)=3))


change A2:A50 to wherever your dates are and change the 3 to 4 to count
April

you can also use a pivot table, use a header than drag that header to the
row
and then the dates into the data field, finally group by month

--


Regards,


Peo Sjoblom



"stevesoul" wrote in message
...
I have two colums, of which column B has months and dates. Sometimes the
date can be up to three times added, or not at all. I can't figure out a
formula to show me how many times Mar was added (12 in the below case) and
Apr was added (6 in the below case).

Number of update Date
1 1-Mar
2 1-Mar
3 1-Mar
4 2-Mar
5 2-Mar
6 2-Mar
7 3-Mar
8 3-Mar
9 3-Mar
10 4-Mar
11 4-Mar
12 4-Mar
13 1-Apr
14 1-Apr
15 1-Apr
16 2-Apr
17 2-Apr
18 2-Apr

Please help and thanks in advance!