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"))