excel giving a #REF error while creating volume vs client type table
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)
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!