Hi,

I have a roster which at the bottom calculates who's on R&R, onsite, etc. I need to count the locals (who do not require accommodation) when they're on site (specified by a number), RDO (specified by "RDO"), Other day off (specified by "O") but NOT when they're on R&R (specified by "RR") as this is counted in another row.

The row containing the local's roster are E21, E49 and E51.

Any help would be MUCH appreciated, I can't get my head around it!!