## Re: Count If Formula with a Defined Range

Here's the workaround that I found:

=SUM(COUNTIF(INDIRECT({"AFME!\$G\$375:\$G\$382","AFME!\$G\$384:\$G\$387","AFME!\$G\$413:\$G\$414","AFME!\$G\$451","AFME!\$G\$453","AFME!\$G\$457","AFME!\$G\$458","AFME!\$G\$462","AFME!\$G\$464:\$G\$465","AFME!\$G\$468:\$G\$472","AFME!\$G\$475","AFME!\$G\$479","AFME!\$G\$511","AFME!\$G\$518","AFME!\$G\$526","AFME!\$G\$534:\$G\$535","AFME!\$G\$537","AFME!\$G\$555","AFME!\$G\$561","AFME!\$G\$565","AFME!\$G\$569","AFME!\$G\$572","AFME!\$G\$575:\$G\$581","AFME!\$G\$585","AFME!\$G\$589","AFME!\$G\$593","AFME!\$G\$596","AFME!\$G\$599:\$G\$606","AFME!\$G\$608:\$G\$610","AFME!\$G\$612:\$G\$617","AFME!\$G\$1118","AFME!\$G\$1134","AFME!\$G\$1153","AFME!\$G\$1158","AFME!\$G\$1182:\$G\$1183","AFME!\$G\$1214","AFME!\$G\$1218","AFME!\$G\$1232:\$G\$1234","AFME!\$G\$1236:\$G\$1242","AFME!\$G\$1247","AFME!\$G\$1251:\$G\$1255","AFME!\$G\$1257","AFME!\$G\$1260","AFME!\$G\$1262","AFME!\$G\$1266:\$G\$1269","AFME!\$G\$1271","AFME!\$G\$1273:\$G\$1275","AFME!\$G\$1278:\$G\$1281","AFME!\$G\$1283:\$G\$1285","AFME!\$G\$1296:\$G\$1297","AFME!\$G\$1322","AFME!\$G\$1334","AFME!\$G\$1336:\$G\$1337","AFME!\$G\$18:\$G\$19","AFME!\$G\$25","AFME!\$G\$43","AFME!\$G\$45","AFME!\$G\$46:\$G\$48","AFME!\$G\$50:\$G\$51","AFME!\$G\$54:\$G\$58","AFME!\$G\$60","AFME!\$G\$62:\$G\$64","AFME!\$G\$66","AFME!\$G\$68:\$G\$72","AFME!\$G\$75:\$G\$77","AFME!\$G\$78","AFME!\$G\$81:\$G\$84","AFME!\$G\$144:\$G\$146","AFME!\$G\$149","AFME!\$G\$150","AFME!\$G\$183:\$G\$184","AFME!\$G\$186","AFME!\$G\$193:\$G\$194","AFME!\$G\$198","AFME!\$G\$200:\$G\$201","AFME!\$G\$255:\$G\$257","AFME!\$G\$269:\$G\$270","AFME!\$G\$272","AFME!\$G\$274","AFME!\$G\$276","AFME!\$G\$278","AFME!\$G\$280","AFME!\$G\$285","AFME!\$G\$298:\$G\$299","AFME!\$G\$301","AFME!\$G\$303","AFME!\$G\$305","AFME!\$G\$307","AFME!\$G\$310","AFME!\$G\$312","AFME!\$G\$318","AFME!\$G\$320","AFME!\$G\$322","AFME!\$G\$324","AFME!\$G\$326","AFME!\$G\$328","AFME!\$G\$331","AFME!\$G\$334","AFME!\$G\$335","AFME!\$G\$336","AFME!\$G\$340:\$G\$341","AFME!\$G\$351","AFME!\$G\$353:\$G\$359","AFME!\$G\$366:\$G\$368"}),"Satisfactory"))