Tag Archives: count months in a pivot

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.

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group