Pivot Table - Averaging Issue in Column

Hi Folks;

I'm a newbie trying to put together a pivot table as shown in the attached sample worksheet. In Column "H" I am trying to match the CMA number to the CMA Label (correct example: H4 matches A6). Everything works until Cell H1376 which gives me an error #DIV/0! instead of 10 (which is in cell A1376). I have tried using number format in both the "Filtered CMA" Worksheet and the "Pivot Table" Worksheet but the error keeps coming up. Would anyone have an idea on how to fix this? Is this a format issue?

Thanks;

O.V.

In the column M is not all values are numbers. Multiply the value by 1

Thanks stasinek!

I hope I can help you down the road!

Best Wishes

O.V.