My idea is countif (I6: I6, "error")... ... Although is wrong, perhaps can give you a little idea!


CodePudding user response:
=COUNTIFS ($5 F, F6, F6, J $5: J6, "error") you see if you wantCodePudding user response:
=COUNTIFS ($5 F, F6, F6, J $5: J6, "error") you see if you wantPage link:https//www.codepudding.com/os/89601.html