# Countifs with 3 Criteria

Options
✭✭✭✭✭✭

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?

• ✭✭✭✭✭✭
Options

In looking at your screenshot of the source data, you only have 2 rows where the Week Number = 43, the Activity = "Tour", and the Location = "Cal Ave". It looks to me like the COUNTIFS is working properly unless there is additional data on the source sheet that is not shown.

• ✭✭✭✭✭✭
Options

In looking at your screenshot of the source data, you only have 2 rows where the Week Number = 43, the Activity = "Tour", and the Location = "Cal Ave". It looks to me like the COUNTIFS is working properly unless there is additional data on the source sheet that is not shown.

• ✭✭✭✭✭✭
Options

@Paul Newcome well don't I feel foolish...it's been that kind of day! You are correct and thank you for taking the time to review my data and point that out. I thought it should work!!

Now where is the delete button for these? ;)

Have a super day!

• ✭✭✭✭✭✭
Options

Hahaha. I have had plenty of those days. No worries.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!