I want to identify the number of iterations of more than one value (e.g, 47 and 54 in more than one range (four ranges).
Here is my cumbersome function as it now stands:
=COUNTIF($I$3:$K$38, 47)+COUNTIF($T$3:$V$32, 47)+COUNTIF($AC$3:$AE$42, 47)+COUNTIF($AK$3:$AM$42, 47)+COUNTIF($I$3:$K$38, 54)+COUNTIF($T$3:$V$32, 54)+COUNTIF($AC$3:$AE$42, 54)+COUNTIF($AK$3:$AM$42, 54)
Can I nest the arguments to downsize the function? Thanks
Here is my cumbersome function as it now stands:
=COUNTIF($I$3:$K$38, 47)+COUNTIF($T$3:$V$32, 47)+COUNTIF($AC$3:$AE$42, 47)+COUNTIF($AK$3:$AM$42, 47)+COUNTIF($I$3:$K$38, 54)+COUNTIF($T$3:$V$32, 54)+COUNTIF($AC$3:$AE$42, 54)+COUNTIF($AK$3:$AM$42, 54)
Can I nest the arguments to downsize the function? Thanks