Hi All,

Again I come to you for some Excel help. I have a file as attached below. Basically I am trying to do two things and it is not working out.

Test1.xlsx

1) In tab Summary, I have tried COUNTIFS formula to calculate the count based on a certain text in Column C&D and month but it does not show the correct value.(Could be the Value format is wrong?) I want to remain the raw data as it is if possible as this is being extracted by someone else.
2) From there on I would like to have each of the count value to have a hyperlink to the raw data and only show those data. I do know Pivot table is another option but would like to know if this is possible or not. :-)

Hope someone can help me out there. :-)

Kind Regards,
Mark.