How to Count how many times a cell is in a column

Louis.Smith ✭✭

06/07/23 in Formulas and Functions

I am struggling with a formula how many times Delta appears in the Client Column.

The formula I am using is:

=COUNTIF((Client:Client), FIND("Delta", Client:Client, >0))

Tags:

• Formulas

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Matt Johnson Community Champion

  06/07/23 Answer ✓

  Hi @Louis.Smith

  Maybe try this one:

  =COUNTIF(Client:Client, "Delta")

  I hope that helps.

  Matt

  Matt Johnson

  Sevan Technology

  Smartsheet Aligned Partner

  0 · Share on FacebookShare on Twitter

Answers

• 

  Matt Johnson Community Champion

  06/07/23 Answer ✓

  Hi @Louis.Smith

  Maybe try this one:

  =COUNTIF(Client:Client, "Delta")

  I hope that helps.

  Matt

  Matt Johnson

  Sevan Technology

  Smartsheet Aligned Partner

  0 · Share on FacebookShare on Twitter
• 

  Louis.Smith ✭✭

  06/07/23

  Thank you this works!

  Do you have an idea of how I can also count how many times a client (Delta) has fleet type B737?

  0 · Share on FacebookShare on Twitter
• 

  Louis.Smith ✭✭

  06/07/23

  https://community.smartsheet.com/discussion/comment/379188#Comment_379188

  Thank you this works!

  Do you have an idea of how I can also count how many times a client (Delta) has fleet type B737?

  0 · Share on FacebookShare on Twitter
• 

  Matt Johnson Community Champion

  06/07/23

  Hi @Louis.Smith

  Sure thing, try:

  =COUNTIFS(Client:Client, "Delta", Fleet:Fleet, "B737")

  I hope that helps.

  Matt

  Matt Johnson

  Sevan Technology

  Smartsheet Aligned Partner

  0 · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list