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
Hi Aprilklfg
That should be:
=SUMPRODUCT(--(MONTH($A$2:$A$284) ='Data Validation'!$C13), --($R$2:$R$284="yes"))
thanks - this gives a result of #value!
any other suggestions?
any other suggestions?