Hi,
I built a target and result for our purchase ledger team, which worked really well as it only considered working days throughout the month daily. The AP Manager would enter a target figure into the green sections, then enter the actually result of the number processed in the Result column, this would be done daily.
Total targets for the month would just look for the columns called Target and add up the row, the same applies for the Result. This worked really well as it was set up Monday to Friday.
Now he wants to extend this to Saturday and Sunday, but wants to record the target figure and Result figures separate to the weekday figures, and now Im stuck on how to separate the sumifs as before it would just add the row up for target and results.
The spreadsheet can be found here This spreadsheet template
so
data is entered in the green sections under Target and Result
the totals are added up in the blue sections
Weekend doesnt work - but the total will include both Sat & Sunday for both Target and Result
Please could you help resolve the weekend formula
Thaks
David.
I built a target and result for our purchase ledger team, which worked really well as it only considered working days throughout the month daily. The AP Manager would enter a target figure into the green sections, then enter the actually result of the number processed in the Result column, this would be done daily.
Total targets for the month would just look for the columns called Target and add up the row, the same applies for the Result. This worked really well as it was set up Monday to Friday.
Now he wants to extend this to Saturday and Sunday, but wants to record the target figure and Result figures separate to the weekday figures, and now Im stuck on how to separate the sumifs as before it would just add the row up for target and results.
The spreadsheet can be found here This spreadsheet template
so
data is entered in the green sections under Target and Result
the totals are added up in the blue sections
Weekend doesnt work - but the total will include both Sat & Sunday for both Target and Result
Please could you help resolve the weekend formula
Thaks
David.