COUNTIF

Options

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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!