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!
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
