COUNTIFs Help.

styless

styless ✭✭✭✭

08/29/22 in Formulas and Functions

Hello, I am trying to count how many times the names appear in the "Career Counselor" column, these are just a few examples, we have a few hundred different names and thought a formula would be easier. I have tried different formulas combinations using "COUNTIFs" without any success, please help. Thank you!

https://app.smartsheet.com/b/publish?EQBCT=960258a100a34a32a0580a9cb3a9de11

Tags:

Formulas

0 ·

Best Answer

Neil Watson ✭✭✭✭✭✭

08/30/22 Answer ✓

=COUNTIF([Career Counselor]:[Career Counselor], [Career Counselor]@row)

0 · Share on Facebook Share on Twitter

Answers

Neil Watson ✭✭✭✭✭✭

08/30/22 Answer ✓

=COUNTIF([Career Counselor]:[Career Counselor], [Career Counselor]@row)

0 · Share on Facebook Share on Twitter
styless ✭✭✭✭

08/30/22 edited 08/30/22

@Neil Watson - Thank you so much! It worked!

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

What do I need to enter for my 2nd criterion range in an index-collect formula?
Hi all, I'm looking for help with an index-collect formula. I want to collect the venue name from an existing sheet using the project name as my criterion. The problem I'm running into is I'm not sure what value to enter for the second criterion range. Below is the formula I currently have, which I know is incorrect. Any…
Countifs for a specific month
The AI-generated formula shows an invalid data type. I'm not sure what is wrong. What I want to do is count the number of items that are good for the month of December. =COUNTIFS([Fault Severity]:[Fault Severity], "good", MONTH([Last Update]:[Last Update]), 12)
TIME Function - Which Time Zone?
I've been looking thru all of the posts regarding the TIME function and can't seem to find where it stated where the time is pulling from. Is it the user's PC time? Is it always Pacific time since that is the Smartsheet default time? How is the time change twice per year addressed? How does a company make sure that any…