COUNTIF Function
Hi All,
I'm looking for assistance with COUNTIF if possible. I have a smartsheet containing 3 Rows of multiple flight departures.
I need to create new columns which will count the following cells for me:
Departure Flight Number
Departure Date
Flight Arrival Time
All of the cells are completed, however when using COUNTIF, I cannot get it to count. I've copied the sheet into Excel and worked for the formula as required there so unsure why I cannot get it work in SS.
Comments
-
Hi,
Can you paste the formula you're using?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello. Countif is for counting a range that matches text. For example if you want values greater then a certain number, or that matches JFK for example.
Let's say you want to count the number leaving from JFK?
=COUNTIF([Outbound Arr Airport]1:[Outbound Arr Airport]3, "JFK")
Just to count the number of rows in the column? Simple as:
=COUNT([Dep Time]1:[Dep Time]3)
https://app.smartsheet.com/b/publish?EQBCT=cbcd9128b5e64541a39a56ff419af747
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!