Adapting formula

Hello again,

been answered so fast and professionally. have great hopes for this next one.

so here's the situation:

I'm entering several measurements for given dimensions, little formula checks if it's inside tolerances

and prints out either X if it's off and Pass if it's in

and at the end of my document if all measurements feature a Pass it prints out Accepted and if not Rejected.

depending on what i'm measuring. the number of different dimension can change.

right now i'm using =if(OR(A1="X",A2="X",A3="X",...), "Rejected", "Accepted)

i'd like my formula to adapt to the number of dimension so if 5 it checks 5 cells, if 10 checks 10 and so on.

Appreciate if anyone can figure it out or if it's even possible


Thank you,

Suspect that you can just use COUNTIF to count the number of X's. I'm guessing that any X is a Reject.

So, just something like:

Formula:

Please Login or Register  to view this content.

Regards, TMS

You're welcome. Thanks for the rep.