help with a formula

Hi All picking your brain here on formulas cant make it work, I am looking to count if:


In my column A the name is DC380 and if corresponding at the value in column A, the value in column B and C is "not done", see an example below:

DC status A Status B

DC480 approved not done

DC280 approved not done

DC380 approved not done

DC480 not done approved

DC280 not done approved

DC380 not done approved


Any Ideas, tried multiple different formulas not working


Note that the count is done on a data sheet and I select reference sheets in the formula


Thank you


Best Answer