Formula or VBA or Combination to count Number of Cells in a merged range! PLEASE HELP!

Hi everyone,

Now before we get cracking, I know how bad Merged Cells are, but trust me, I have no way around it. I have created a visual diary in Excel to track how much time people in my office are spending on projects. Each Cell represents a block of time, let's say 15 Minutes, and then if a member of staff works on a project for 3.5 hours, they select 14 cells in that day's column, merge them, and input the initial of the project, which then gets automatically coloured using conditional formatting. This is the quickest and most efficient input method that ALSO allows me to see the days too and how they break down, rather than just a lump sum of the total time they spend that day...if that all makes sense...

Then at the bottom of each column I was looking to have a cell for each formula which would effectively count how many cells are occupied by each initial INCLUDING COUNTING ALL THE CELLS IN THE MERGED RANGES.

I have attached a spreadsheet as an example which should illustrate my point, but of course, if there are any questions, please do ask me and I will answer!

Also, apologies if I listed in the wrong section, as not sure what the best solution is. Would prefer forumlas if I can have it rather than VBA, but happy to use some VBA to create functions of what have you that then feed into a formula?!

Thanks!




Chris