Count If Formula with a Defined Range

[squeakums]

How would you write a countif formula using a defined name range?

My range: =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$76:$G$77,AFME!$G$75:$G$77,AFME!$G$78,AFME!$G$81:$G$84,AFME!$G$144:$G$146,AFME!$G$149,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,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$1306,AFME!$G$1315:$G$1316,AFME!$G$1322,AFME!$G$1334,AFME!$G$1336:$G$1337

That's why its defined to just = YG

I wrote this formula and it doesn't work:

=COUNTIF(YG,"Satisfactory")

Help? Thanks!

 

[squeakums]

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