mercredi 25 février 2015

Excel COUNTIFS count months in date range

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