Countifs with 3 Criteria

Andrea Westrich

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?

Paul Newcome

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.

Paul Newcome

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.

Andrea Westrich

@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!

Paul Newcome

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