Counting empty cells in a column with merged cells.

[selbysam]

Please help me. I want a forumla at the bottom of each column to show the number of hours worked that day. I thought it could be based on counting the number of empty cells, multipling that by 30 mins, and subtracting that from the total number of hours availble on the schedule. This has become much more difficult with the merged cells but the merged cells are what make the schedule look nice and easy to use.

https://ddpsc-my.sharepoint.com/personal/sselby_danforthcenter_org/Documents/TechSchedule.xlsx?web=1
This is the link

 

[jasonb75]

This has become much more difficult with the merged cells but the merged cells are what make the schedule look nice and easy to use.

They are also one of the biggest causes of failing formulas. If you merge 4 cells together, 3 of them are blank / empty. Only the top left cell of the merged range holds the value.

There might be other ways to do what you need but without seeing a visual representation it is impossible to say. Many members of the forum are not able to download linked files due to security restrictions / concerns. It would be preferable if you posted an example using the XL2BB add in.