COUNTIF Function

Matt Wood
Matt Wood ✭✭✭
edited 12/09/19 in Formulas and Functions

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.

Untitled.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!