Pivot Chart not displaying correct data

Originally Posted by benishiryo

hi Alex. when you have data that are not numbers in your source (blanks in this case. some scenarios have text), then the Pivot will use COUNT instead of SUM. so B9 is saying that there is a record count of 3 entries for Benjamin Wade. right-click any cell under B4 & select Summarize Data By -> Sum. that should get you what you want?

Perfect! Thank you so much, I've been stumped on this for quite a while!

Thanks again benishiryo