I want to count how many hours (rows) are accounted for for specific tasks eg: VIP, OPT, 1 to 1
Each row represents 15 min. and the way my template works is by merging a certain amount of cells to represent the length of time.
Each task can be of different lengths. some are 4 cells, some are 9 cells.
I need a count formula to find the amount of rows that are being merged for the specific task.
I know Its never a good idea to use merged cells but for this i have no choice.
In which sheet do you need the counting to happen?
Where should the output be displayed?
In what format should the output be displayed?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks