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 ✭✭✭✭✭✭

  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 ✭✭✭✭✭✭

  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 ✭✭✭✭✭✭

  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

Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list