I am trying to show the percentage of deliveries on time in a weekly summary.
I am picking up the total from each day using = then the cell on the tab for each day of the week.
The cell for each day displays percentage fine, 80% etc but the cells in the weekly summary display #VALUE!
I have tried to change the cells in the row to percentage etc but nothing seems to work.
Any ideas please??
Bookmarks