Count Months in a Pivot List (Formula)

Posted on by Datanology


=COUNTIF(A:A,"Jan")+COUNTIF(A:A,"Feb")+COUNTIF(A:A,"Mar")+COUNTIF(A:A,"Apr")+COUNTIF(A:A,"May")+COUNTIF(A:A,"Jun")+COUNTIF(A:A,"Jul")+COUNTIF(A:A,"Aug")+COUNTIF(A:A,"FSep")+COUNTIF(A:A,"Oct")+COUNTIF(A:A,"Nov")+COUNTIF(A:A,"Dec")

This formula counts all the occurrences of a month in the list when using multiple years and you need to know how many months it covers.




Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us

Datanology