# COUNTIFS issue, output is always zero

I have no idea what I'm doing, considering there's plenty of topics on COUNTIFS. However, each solution I've tried, as well as my own solutions, which I shall list, end up in the same thing... ZERO. It counts several cells and ends up as a zero, and I have no idea why, please help.

So far I've used:

=COUNTIFS(G:G,"A",G:G,"M",G:G,"TM")

=SUM(COUNTIFS(A:A,"Active",G:G,{"A","M","TM"}))

pick one you like:

="Staff Roster - "&COUNTIF(G:G, "A")+COUNTIF(G:G, "M")+COUNTIF(G:G, "TM")

="Staff Roster - "&ARRAYFORMULA(COUNTA(IFERROR(REGEXEXTRACT(G:G, "A|M|TM"))))

="Staff Roster - "&COUNTA(IFERROR(QUERY(G:G, "where G='A' or G='M' or G='TM'")))

="Staff Roster - "&ARRAYFORMULA(SUMPRODUCT(REGEXEXTRACT({B3, B6, B12}, "\d+")))

="Staff Roster - "&COUNTA(G3:G)

="Staff Roster - "&COUNTA(IFERROR(FILTER(G:G, G:G<>"Rank")))

="Staff Roster - "&ARRAYFORMULA(SUM(IF((G:G="A")+(G:G="M")+(G:G="TM"), 1, )))

="Active Staff Roster - "&COUNTA(IFERROR(FILTER(B:B, B:B="Active")))

="Active Staff Roster - "&COUNTIF(B:B, "Active")

• Once again, you've given more than I could ask for. Thank you, with all those options, I've modified it even further for my needs, thanks for showing me how its done! – Nate.M-C Apr 23 at 5:12