Forum Discussion
Solved
COUNTIFS, counting date range and word
Hello I am trying to create a formula to count the occurrences of a particular month and if an adjacent cell contains Yes Say column A2:A284 are dates dd/mm/yyyy and column R2:R284 contains either...
RE. this gives a result of #value! any other suggestions? NO, this works no problem (sample attached):
==> How to correct a #VALUE! error in the SUMPRODUCT function
