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

Louis.Smith

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

Matt Johnson

Hi @Louis.Smith

Maybe try this one:

=COUNTIF(Client:Client, "Delta")

I hope that helps.

Matt

Matt Johnson

Hi @Louis.Smith

Maybe try this one:

=COUNTIF(Client:Client, "Delta")

I hope that helps.

Matt

Louis.Smith

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?

Louis.Smith

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?

Matt Johnson

Hi @Louis.Smith

Sure thing, try:

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

I hope that helps.

Matt