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)
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.