Countifs with 3 Criteria

I should be able to do this, but I appreciate this group who I know will help.

This is my source sheet

This is the sheet where I have my formula for a total, line 10.

I need to count everything in the Source sheet where the activity is Tour, the Location is Cal Ave and the Week Number is the Current week in Row 19 of my formula sheet, -1.

I've tried doing 3 CountIf statements with a plus between them, but it gives me 28 (The total should be 4) and I've tried the formula below, but it gives me 2.

=COUNTIFS({Activity}, "Tour", {Location}, "Cal Ave", {Week1}, [Weekly Metrics]$19 - 1)

What am I doing wrong?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!