KyleJackMorrison
Board Regular
- Joined
- Dec 3, 2013
- Messages
- 107
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hello,
I have a document linked below where i use it for my work where its used a calendar. In this document it has where people are, this means some cells are merged and some aren't depending if they are away or not.
I have to complete a weekly manning report where i have to count how many people are either, available, on course, sick leave, meeting, or if they are available AND have a first aid qual.
I would normally use formulas however they don't really work with merged cells. Is there a way to count the values in a column? Would it be easier to count if the cells are coloured. it'll make more sense in the document.
Many thanks in advance!
I have a document linked below where i use it for my work where its used a calendar. In this document it has where people are, this means some cells are merged and some aren't depending if they are away or not.
I have to complete a weekly manning report where i have to count how many people are either, available, on course, sick leave, meeting, or if they are available AND have a first aid qual.
I would normally use formulas however they don't really work with merged cells. Is there a way to count the values in a column? Would it be easier to count if the cells are coloured. it'll make more sense in the document.
HTML:
https://www.dropbox.com/s/t1za85u9dddebog/Public%20Sheet%20Test.xlsm?dl=0
