I'm new so I am sorry if I am not as concise, I am trying to explain it but not very well
I have a log of workflow and I want to produce performace stats.
In particular I'd like to use the Date closed to link into a table which will look at the row of date Closed and be able to count the number of items closed each month.
01 January 2011
01 January 2011
25 January 2011
25 January 2011
05 February 2011
06 February 2011
03 March 2011
15 June 2011
17 June 2011
Ideal output
January 4
February 2
March 1
June 2
Look at the help file for COUNTIF - you can use the MONTH function to extract the month number from a date. Alternatively, have a look at pivot tables...
Hi
Welcome to the forum
Try for January
=SUMPRODUCT((Month($A$1:$A$100)=1)*($A$1:$A$100<>""))
Change the 1 to 2 for February, 3 for March etc.
Or better still if January was in cell D1 entered as 01 jan 2011 but formatted as "mmm" so it shows as Jan, then dates for other months in D2,D3 etc., enter in E1
=SUMPRODUCT((Month($A$1:$A$100)=D1)*($A$1:$A$100<>""))
and just copy down
--
Regards
Roger Govier
Microsoft Excel MVP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks