Count Product

Hello.

I am trying to determine based on date how many times a region comes up and then count

i have date in column B and Region in Column H.

I want in the chart I created to count the # of times one region appears on a specific Date.

please see attached!

Thanks

Perhaps you could use a Pivot Table?

Hello

I am currently using a Pivot table, but running into an issue as it does not auto refresh, so i have been tasked with doing it using a formula!.

right now i am using this formula to calculate the sum
=SUMPRODUCT(--('Nov 27th - Dec 3rd'!$H$2:$H$198=$B$1),--('Nov 27th - Dec 3rd'!$B$2:$B$198=A2),'Nov 27th - Dec 3rd'!$G$2:$G$198)

i want to do the count rather then sum