Count range of cells if not next to each other

Hi Ramananhrm,

That could work however, the range is split as indicated above so its not one complete range. Its actually 3 sections of a column.