COUNT certain cells (not range) that contain certain data

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!!

Can you please upload the worksheet, or a sample worksheet as this will make finding a solution for you a lot easier. Thanks.

OK I've uploaded an edited version as the correct one contains confidential info.

I need the "Accommodation NOT Required" to count the Local personnel (row 10 and row 12) if the cell displays anything other than "RR". Including a number, HOL, O, RDO.

Yes sorry I mean 9 and 11.

I'm not counting a range, just two specific cells therefore it comes up with an error when I type that formula..

You can use this:

=COUNTIFS($C$8:$C$11,"LOCAL",F8:F11,"<>RR")

Hope this helps!!!

Hi bhenlee, I think you're on the right track but it's not counting correctly.

Attached is the actual roster I'm working on, see row 80 which is where I need the answer projected.

If column C equals "Karratha - Local" and column F equals a number >0 I need it to count. I don't want it to count if column F equals R&R as this is already counted in row 76.

I also need it to count when there is a DV in colum F which is why I have the forumla COUNTIFS(F19:F74,"DV")

Thanks!