Count Months in a Pivot List (Formula)


=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
the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group