COUNTIFS & CONTAINS in Summary

Options

Hi all, I tried the following method in Sheet Summary to gather information but seems like it does not work from the sample I found form other discussion.

Can anyone help me on it?

Thank you.

Answers