Formula not working

Nasir@EBC

Hi

The following formula in my summary sheet is giving 6 as the result, which is incorrect. The correct number is 87.

=COUNTIF({Record ready}, <>"Yes")

When I create a filter in the source sheet, it is giving the correct result that is 87 records.

Any clues please?

Bassam Khalil

Hi @Nasir@EBC

Hope you are fine, please try the following formula:

=COUNT(COLLECT({Record ready}, {Record ready}, @cell <> "YES"))

Or The Following Formula

=COUNTIFS({Record ready}, @cell <> "YES")

Nasir@EBC

Hi Bassam

Unfortunately it did not work.

I'm pretty sure there will be some way out!

Bassam Khalil

Hi @Nasir@EBC

Bassam Khalil

@Nasir@EBC

Am sure that the 2 formula is 100% working because i test it but i think you need to rectify the reference if you copy and paste it.

if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

Nasir@EBC

Hello Bassam

Thanks for the support!

I have just shared both the sheets with you with Edit rights.

Bassam Khalil

I tried to login but no access