Counting coloured cells based on conditional formatting

Did that heading make sense!?

I have a gantt chart which uses conditional formatting to show the duration of task at hand.
In this case when staff have accommodation booked (start date through to finish date)
What I want to do is simply count the number of coloured cells (its the standard colour green) on the bottom line (starting on F98 and going through to DY98) therefore giving me a sum of employees accommodated on anyone day.

Gantt_Chart.jpg

Thanks in advance for your help


Cheers,
matt

Why not jsut sum the days accomodation is booked?

I have in column;
A - name
B - position
C - department
D - start date
E - finish date

Column D & E make up the gantt chart

Try this

=SUMPRODUCT(--(D2:D20<>""),--(E2:E20<>""),--(E2:E20-D2:D20+1))