Averaging the number of "yes" each month
Answers
-
Try something more like this:
=COUNTIFS(Date:Date, AND(....................), Headache:Headache, @cell = "Yes") / COUNTIFS(Date:Date, AND(....................), Headache:Headache, @cell <> "")
-
Hi Paul,
Thank you very much. Can you say what is AND(....................)? Unsure what this is
-
It is the same AND criteria you have in your existing formula for the Date:Date range.
-
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?
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!