Hello,

I am trying to create a summary sheet from raw data using the =countifs function,

=COUNTIFS(Sheet1!$F:$F, "criteria1",ticketslist_131238438121361074!$G:$G,"criteria2", ticketslist_131238438121361074!$B:$B, "criteria3")

I have a 4th column I want to evaluate and it is a date field. I need to be able to evaluate what month that date appears in to populate this structure,

Apr May Jun Jul Aug
Activity Closed Closed Closed Closed Closed
Criteria1 1 0 8 22 3
Criteria2 4
Criteria3 20


Can you someone help please,
thanks