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 web designer group uk
the webdesigner group logo

Close Button

Web Site Designed by

The Web Designer Group