Countif or countifs - please help

Hi. I'm having a problem (I’m probably missing the obvious or I’m stupid).
This is my first time engaging with you so please be understanding

Essentially, I have a spreadsheet with 15 tabs, I want the master copy tab to count the number of Yes, No, N/A and blank cells on each row for the other spreadsheet tabs in their F Column. The F Columns of the other tabs (i.e. Burford, Chichester etc –there are 14 of them), have conditional formatting so that an input of Yes will turn the cell to Green, No to Red etc.

All I want to do is to correctly formulate the Master Copy tab so that it will count as follows:

Column C on the master copy should count all tabs where the input in the F column on the other tabs is “Yes”.
Column D on the master copy should count all tabs where the input in the F column on the other tabs is “No”.
Column E on the master copy should count all tabs where the input in the F column on the other tabs is “N/A”.
Column F on the master copy should count all tabs where the input in the F column on the other tabs is blank.

Can you help with this pleeeeeeeeeease?

Thanks
David

Instead of using one countifs, use multiple countif and add them all up. This is how I suggest doing it unless theres an easier way without adding up 15 count ifs)

For example, in column C of the master copy you should have something like this

Please Login or Register  to view this content.

The criteria would be a cell that says yes.