Hi. I was trying to complete this class but when i changed "01" to C11, it appeared REF! Can someone explain me why?

Hi Ana, thanks for reaching out! First I'd add the IFERROR statement in the cell, to avoid the potential error of having an empty cell (4:22) in the video. One of the other reasons you might be getting the error is if you've not fixed all the cells correctly. You ought to add $ in C$11 and C$12. Lastly are the years in your report of type date? That's the next thing I'd check and make them dates if they're not. If doesn't resolve the issue you should try the formula and replacing the references step by step to see when the error arises. Let me know if you have any further issues! Best, 365 Eli

Follow this topic

Ana Bernardo

Last answered:

21 Nov 2022

Posted on:

20 Nov 2022

My GETPIVOTDATA is not working

in The Complete Data Visualization Course with Python, R, Tableau, and Excel / Dashboard in Excel – Tables -Calculating Net Sales

1 answers ( 0 marked as helpful)

Elitsa Kaloyanova

Instructor

Posted on:

21 Nov 2022

My GETPIVOTDATA is not working

Submit an answer

related questions