If Then Formulas

Crystal Panning

Hi, 

Is there a way to do an If/Then formula for obtaining a count if a certain word is typed in a cell so that the count automatically adds one for each time the word is entered? 

 

Thank you,

Crystal

Paul Newcome

Do you mean counting how many times a word is entered into the same cell or how many times a word is entered across a range of cells?

Mike Wilday

In addition to Paul's question, I have this one: will the cell only contain that one word or does each cell contain a paragraph of words that might contain that one word? 

Andrée Starå

Hi Crystal,

To sum it up! 

Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Crystal Panning

It would count how many times a word is entered across a range of cells. 

Crystal Panning

The cell would only contain that one word. I have attached an example of what I am hoping to have. So essentially one column would be for the name of the Brands, the other column would be the counts that I am hoping a formula could help pre-populate when one of the brands is entered via a dropdown in the third column.

Crystal Panning

Just posted a screen shot, let me know if you need more information for this. Thank you all for your help!

Andrée Starå

Thanks!

Try something like this.

=COUNTIF([Brand Counts]:[Brand Counts]; Brands@row)

The same version but with the below changes for your and others convenience.

=COUNTIF([Brand Counts]:[Brand Counts], Brands@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Paul Newcome

Try something along the lines of this...

 

=COUNTIFS(Brands:Brands, [Brand Counts]@row)

Andrée Starå

Edit: Changed column names. (I' can't update my original post)

=COUNTIF([Brands]:[Brands]; Brand Counts@row)

The same version but with the below changes for your and others convenience.

=COUNTIF([Brands]:[Brands], Brand Counts@row)

Paul Newcome

@Andree,

 

You forgot your square brackets around the [Brand Counts] column name.

Andrée Starå

@Paul,

Thanks!

Now I can't update the second post either so here it is again.

@Crystal

Try something like this.

=COUNTIF(Brands:Brands; [Brand Counts]@row)

The same version but with the below changes for your and others convenience.

=COUNTIF(Brands:Brands, [Brand Counts]@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Paul Newcome

Are you getting blocked again? I haven't had that problem in a while...

Andrée Starå

Occasionally it happens, and I thought it was because of how soon I changed the post. It's probably set to strict for a community/forum I believe.

Paul Newcome

I've done updates as soon as the page reloaded after clicking on "Post" with no issue. At least it's not every other post getting blocked like it was a while back. THAT was painful.

Andrée Starå

Sometimes it works and sometimes it doesn't!