Countifs based on date range and value of cells in a column

Hello,

I am having issues with the formula below I created, the middle portion of the formula has a COUNTIFS ">=9", I am trying to calculate a count of numbers greater than 9 between a date range, then divide that by the total count of all numbers in that same date range and multiple that by 100.

I am getting a too few arguments at the ">=9".

=COUNTIFS('Survey Data'!AV2:AV1000000,'Survey Data'!Z2:Z1000000,">="&A2,'Survey Data'!Z2:Z1000000,"<="&B2,'Survey Data'!AV2:AV1000000,">=9")/COUNTIFS('Survey Data'!AV2:AV1000000,'Survey Data'!Z2:Z1000000,">="&A2,'Survey Data'!Z2:Z1000000,"<="&B2)*100

I appreciate any help.

Nick

You don't have a condition term following your first range - you just have:

... 'Survey Data'!AV2:AV1000000 ...

in both COUNTIFS functions. Are you getting confused with the SUMIFS function, where you would have the sum_range before the (condition_range and condition) pairs ?

Hope this helps.

Pete

Thanks 6StringJazzer, what would be the best way to count based on a date range like I have but only count the values that are >=9?

Yeah Pete, I always have trouble with Countif & Sumifs

Jeff has given you the answer - delete the parts that he shows in red.

Hope this helps.

Pete

Got it, thank you both!