Forum Discussion

Copper Contributor

Aug 18, 2022

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...

excel

Formulas and Functions

Lorenzo
Aug 18, 2022
Aprilklfg

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

SAMPLE_Aprilklfg.xlsx22 KB

Lorenzo

Silver Contributor

Aug 19, 2022

BTW Aprilklfg

If by any chance you run Excel 2021 or 365, an alternative:

=COUNTA(FILTER($R$2:$R$284, (MONTH($A$2:$A$284) ='Data Validation'!$C13) * ($R$2:$R$284="yes")))

=ROWS(FILTER($R$2:$R$284, (MONTH($A$2:$A$284) ='Data Validation'!$C13) * ($R$2:$R$284="yes")))