Sign in to join the conversation:
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
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?
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?
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
It would count how many times a word is entered across a range of cells.
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.
Just posted a screen shot, let me know if you need more information for this. Thank you all for your help!
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?
Try something along the lines of this...
=COUNTIFS(Brands:Brands, [Brand Counts]@row)
Edit: Changed column names. (I' can't update my original post)
=COUNTIF([Brands]:[Brands]; Brand Counts@row)
=COUNTIF([Brands]:[Brands], Brand Counts@row)
@Andree,
You forgot your square brackets around the [Brand Counts] column name.
@Paul,
Now I can't update the second post either so here it is again.
@Crystal
=COUNTIF(Brands:Brands; [Brand Counts]@row)
=COUNTIF(Brands:Brands, [Brand Counts]@row)
Are you getting blocked again? I haven't had that problem in a while...
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.
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.
Sometimes it works and sometimes it doesn't!
I submitted a ticket, but thought I would ask here. I am having an issue with sheets that I own (our org is on a Business plan). For the last two years, we have been using the sheets without an issue - our admin and many Editors (all shown as Guest since they are outside of our organization) were able to edit the sheets…
Hello! I’ve noticed for a LONG time that when I change the name of a column in a source sheet, the corresponding column in reports breaks, which then causes dashboard widget charts (that rely on those reports) to fail. Is there a way to: Prevent this issue when renaming columns? Fix existing reports and dashboards without…
Dear All, my account was suspended for a long period in which my sheets were deleted. I renewed my account and asked technical support if my sheets could be recovered. I received this message below, but I do not seem to get a reply back afterwards and still do not have my sheets recovered. Thanks for…
