Averaging the number of "yes" each month

Vinton Douglas

Paul Newcome

Try something more like this:

=COUNTIFS(Date:Date, AND(....................), Headache:Headache, @cell = "Yes") / COUNTIFS(Date:Date, AND(....................), Headache:Headache, @cell <> "")

Vinton Douglas

Hi Paul,

Thank you very much. Can you say what is AND(....................)? Unsure what this is

Paul Newcome

It is the same AND criteria you have in your existing formula for the Date:Date range.

Vinton Douglas

Hey Paul,

This is what i used an its not woking:

=COUNTIFS(Date:Date, AND(Date:Date), Headache:Headache, @cell = "Yes") / COUNTIFS(Date:Date, AND(Date:Date), Headache:Headache, @cell <> "")

Another point is, how do i average a particular month and not the entire data?

Paul Newcome

The formula you have in your original post does not use a range inside of the AND function. The AND portion from the formula in your original post would go in the AND portion of my formula.