Hello
I have a basic understanding of spreadsheets and formulas but am out of my depth and need your help and advice!
I have a workbook that has multiple spreadsheets. The first is a summary sheet, the others are for each year. I would like the summary sheet to show the number of times a type of job is won per month.
At the moment when the job is won, on the Year Worksheet (e.g. 2017) I put the month and year it was won in Column A (e.g. 1.18 for January 2018, 11.17 for November 2017, 9.16 for September 2016 etc) and the type of job in Column M.
A job might be listed on one worksheet (e.g. 2017) but it might be won in January 2018 meaning Column A will show as 1.18.
I hope this makes sense, and I appreciate any help you can give me.
ThanksWORKSHEET 'SUMMARY'
<tbody>
</tbody>WORKSHEET '2018'
<tbody>
</tbody>WORKSHEET '2017'
<tbody>
</tbody>WORKSHEET '2016'
<tbody>
</tbody>
I have a basic understanding of spreadsheets and formulas but am out of my depth and need your help and advice!
I have a workbook that has multiple spreadsheets. The first is a summary sheet, the others are for each year. I would like the summary sheet to show the number of times a type of job is won per month.
At the moment when the job is won, on the Year Worksheet (e.g. 2017) I put the month and year it was won in Column A (e.g. 1.18 for January 2018, 11.17 for November 2017, 9.16 for September 2016 etc) and the type of job in Column M.
A job might be listed on one worksheet (e.g. 2017) but it might be won in January 2018 meaning Column A will show as 1.18.
I hope this makes sense, and I appreciate any help you can give me.
ThanksWORKSHEET 'SUMMARY'
A | B | C | D | |
Month Won | Month Won | Month Won | ||
1 | Job Type | 6.16 | 4.17 | 1.18 |
2 | Washing | 1 | 2 | 0 |
3 | Ironing | 1 | 1 | 1 |
4 | Cleaning | 0 | 0 | 2 |
<tbody>
</tbody>
A | M | |
1 | 4.17 | Washing |
2 | 6.16 | Ironing |
3 | 1.18 | Cleaning |
<tbody>
</tbody>
A | M | |
1 | 6.16 | Washing |
2 | 4.17 | Ironing |
3 | 1.18 | Cleaning |
<tbody>
</tbody>
A | M | |
1 | 4.17 | Washing |
2 | 1.18 | Ironing |
3 | 4.17 | Cleaning |
<tbody>
</tbody>