thorpyuk
Well-known Member
- Joined
- Mar 14, 2006
- Messages
- 1,453
Hiya,
Making an easy job complicated, i have a spreadsheet with colleague days off on holidays.
Down column A are my colleague names, and then across the next 5 columns are monday-friday. This is then replicated down rows for each week, so week 1 is directly under week 2 etc etc.
Now in a cell where someone is off on holiday is either "hol" for 1 days holiday, or "hol half day" for a half days holiday.
How might i use sumproduct to add up all a persons holiday days taken?
Thanks!
Making an easy job complicated, i have a spreadsheet with colleague days off on holidays.
Down column A are my colleague names, and then across the next 5 columns are monday-friday. This is then replicated down rows for each week, so week 1 is directly under week 2 etc etc.
Now in a cell where someone is off on holiday is either "hol" for 1 days holiday, or "hol half day" for a half days holiday.
How might i use sumproduct to add up all a persons holiday days taken?
Thanks!