Counting empty cells in a column with merged cells.

selbysam

New Member
Joined
May 18, 2021
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
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
 
Last edited by a moderator:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
13,138
Office Version
  1. 365
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,136,274
Messages
5,674,777
Members
419,524
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top