help with a formula

deemeilo

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

Paul Newcome

Try this...

=COUNTIFS(DC:DC, @cell = "DC480", [Status A]:[Status A], @cell = "Not Done") + COUNTIFS(DC:DC, @cell = "DC480", [Status B]:[Status B, @cell = "Not Done")

Paul Newcome

Are you able to provide some screenshots for reference?

deemeilo

Yes of course

i would like to count

DC480 not done = 2 (cumulating status A and B answering to the criteria)

Paul Newcome

Try this...

=COUNTIFS(DC:DC, @cell = "DC480", [Status A]:[Status A], @cell = "Not Done") + COUNTIFS(DC:DC, @cell = "DC480", [Status B]:[Status B, @cell = "Not Done")