i dont know why its giving me this error im doing everything as done in the lec help would be appreciated thnx! (P.S. its not because of the year and month cells i checked it)

Hi ROHAN, thanks for reaching out! In the end of the formula instead of "Big-box" you should have the cell reference instead - $D42 in your case. Also make sure that you've fixed all the relevant sales, as otherwise you might not get an accurate result for the remaining cells in the table. Let me know if this helps! Best, 365 Eli

Follow this topic

ROHAN MOHAN GAIKWAD

Last answered:

02 Dec 2021

Posted on:

13 Nov 2021

excel giving a #REF error while creating volume vs client type table

in The Complete Data Visualization Course with Python, R, Tableau, and Excel / Dashboard in Excel – Charts - Bar and Line Combination Chart

1 answers ( 0 marked as helpful)

Elitsa Kaloyanova

Posted on:

02 Dec 2021

excel giving a #REF error while creating volume vs client type table

Submit an answer

related questions