How to count how many times an specific name in a column has a "Pass" in another column?

BSmartSheet

Hello community,

I have a Calculation sheet and I want to track how many times specific names have a "Pass" and or "Fail" in another sheet. I have a dashboard I'm connecting this calculation sheet to.

For example how many "Pass" in column 2 does "john" in column 1 have

BSmartSheet

I was able to figure it out

=COUNTIFS([{Name Column}, "Specific Name", {Status Column}, "Pass")

BSmartSheet

I was able to figure it out

=COUNTIFS([{Name Column}, "Specific Name", {Status Column}, "Pass")