Creating a summary tabe that contain number of activites from long list shutdown plan

[saifsawafi]

Hello to all.
Currently I'm looking at a gas processing plant shutdown progress. I have a long list of activities to be executed on daily basis (column C). I would like to create a summary table that shows number of activity type against execution day. I have attached a file with an example of what I need exactly.
Your help on the above will be highly appreciated.

[shukla.ankur281190]

Try

G3=COUNTIFS($B$3:$B$918,$F3,$C$3:$C$918,G$2) and drag as you need.

[samba_ravi]

Or can use pivot table see the attached file

[saifsawafi]

Thanks a lot it worked as I expected,

Best regards

[saifsawafi]

Thanks a lot. Now I have 2 option either pivot table or using function.

Best Regards
Saif