Hello I am trying to create a count if function-
My current sheet, Assigned Counter needs to return a tally with each "article" assigned to a trainer.
So under the articles assigned i'm trying to use a countif function to return the number of articles assigned to a specific trainer.
I am trying to use
=COUNTIF(Request Tracker Working Sheet Range 2},Trainer@row ** the Trainer@Row information is on my current sheet Assigned Counter. and my Range- Request Tracker Working Sheet Range 2- is referencing a different sheet- I keep getting an unparseable error.
How can i get it to return the number of articles assigned to a specific Trainer listed on my current sheet i am working?
Help Article Resources
Check out the Formula Handbook template!