C
carl
Hello All.
I use this formula
=SUMPRODUCT(--(BOX!A5:A280=Sheet1!B12);--(BOX!I5:I280=TRUE))/COUNTIF(BOX!A5:A280;Sheet1!B12)
The range that it is looking at has values like #NUM! and the formula
returns #NUM!.
Is there a way to modify the formula so that it ignores the #NUM! ?
Thanks you in advance.
I use this formula
=SUMPRODUCT(--(BOX!A5:A280=Sheet1!B12);--(BOX!I5:I280=TRUE))/COUNTIF(BOX!A5:A280;Sheet1!B12)
The range that it is looking at has values like #NUM! and the formula
returns #NUM!.
Is there a way to modify the formula so that it ignores the #NUM! ?
Thanks you in advance.