View Single Post
  #1   Report Post  
LHorse
 
Posts: n/a
Default the answer to appear in more than one cell

Using a spreadsheet I need a chart that would return the answer across the
rows.
Where the total is equal to the starting number. To answer how many lessons
can be taught each day to achieve the goal per week. My problem lies in that
I need whole numbers.
example
Goal per week 21
Sunday 8
Monday 4
Tuesday 3
Wednesday 2
Thursday 2
Friday 2

Total 21

Thanks Laura