Hi, why i get error on Gross Sale Income formula? i can't figure it out. hope someone will give ans.
in
Data Analysis with Excel Pivot Tables
/
GetPivotData is great! Extracting data from the Master Pivot Table

1 answers ( 0 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Hi Bernie Tabuzo,
If you are using the worksheets provided for the course, there is a 'spacer' row between Volume and Gross Sales Income, so $B7 references an empty cell. I suggest it should be $B8 - see if that works.

Regards,
Kev T.