Calculate "Closed" by Month

K

K142

Hi All,
In Excel I type in "incident detail" (e.g. "internal phone issue"),
"Date of incident" (e.g. "18 Jan 2008"),
and Incident "Open" or "Closed".
How do I graph how many incidents were Opened by calendar month?

All assistance appreciated,
K142
 
B

Bob Phillips

Create a table of month names down column M say, and column N would be

=SUMPRODUCT(--(TEXT($A$2:$A$200),"mmm")=M2),--(YEAR($A$2:$A$200)=2008),$B$2:$B$200)

copy down and then chart that table.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top