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.

Find more posts tagged with

Formulas

Comments

Andrée Starå

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

Nick Burrus

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

Sign in to join the conversation!

Quick Links

Trending discussions

Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
INDEX/COLLECT??
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…