I'm currently using the =COUNTIFS() function to count the number of values that satisfy two conditions.
=COUNTIFS('2014'!$F:$F, B3, '2014'!$H:$H, A13)
However I no want to also include specific months as a condition, but the range of dates is in the format, 3/11/2014. I have looked up a few different ways that can count specific months from a list of dates using a combination of the =SUMPRODUCT() and MONTH formulas, but unable to find one that works in a COUNTIFS function to satisfy the original conditions also.
I even tried to think outside of the box by using wild cards,
=COUNTIFS('2014'!$F:$F, B3, '2014'!$H:$H, A13, '2014'!$A:$A, "*/11/2014")
Alas to no avail.
Does anyone know if there is a way in which to include counting specific months to a =COUNTIFS() function?
Aucun commentaire:
Enregistrer un commentaire