Quote Originally Posted by RonZ
...but I am elated that you did it!
Glad I could help.

Can you go over the problem solving process you used to get to the solution?
Well, I knew that since the dropdown was a list, that it had to be respresented in a collection somewhere. So I opened up my Excel book (read my profile for a description of the books.), until I figured out Visible = True was how Excel determined how it used the items.

Then I had to figure out the object name. I recorded a macro selecting one, then two months. That showed me the names used. (PivotFields("Month").PivotItems(X))

The next step was iterating through the collection. When I found one visible, add 12 to the total number of shifts. AddShift = AddShift + 12.

Finally, move all that into a UDF function so it could be used in a sheet function.