Formula
=query(A:B,"select count(B) where (A = 44)",)
Explanation
As the values on column A are numbers, QUERY set the column data type as number. Enclosing a number between single quotes/apostrophes makes it to be a string, so comparing a string to a number returns FALSE.
To remove the header try
=query(A:B,"select count(B) where (A = 44) label count(B) ''",)
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")
Best Answer
Since you have already tried the query solution, please use these two formulas:
in cell
B2
:in cell
D2
:You can read more about how the QUERY function works in the help center.
Note: In the end of the formula we use
label count(D) ''
. That translates to "take the label of the results in column D and replace it with nothing. Try omitting that part of the formula and see what happens ".