Forum Discussion
COUNTIF across multiple sheets, within a specified range for each sheet
Hello hello, Im creating a monthly spreadsheet to track my teams performance and one of the metrics my department tracks scales with how many shifts they worked. My goal was to use COUNTIF to...
arodriqs It would be better if you share a sample file showing your desired output. Then contributors can understand your problem clearly and put best answer. However, from my assumption, I have putted few of a name to 3 sheets and shown how to count them in a summery sheet. See the attached file.
=LET(x,TOCOL(Sheet2:Sheet4!A2:A100,1),GROUPBY(x,x,COUNTA,,0))