I'm sure my answer has already been posted, but I've tried searching and
nothing seems to fit.

I want to count the number of cells in a range where the value of column A
is "1", and the date in column B is within the month of August. I will then
in a separate cell need to average the numbers in column C, where A=1 and
B=sometime in August.

I've tried sumproduct and countif's for the first one but nothing seems to
work. And for the second one, getting the average to work only during those
conditions is stumping me.

Thanks in advance for all help!