Jan 25, 2022
I want to add up a specific word in a column based on what it says in another column.
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Jan 26, 2022
In cell F34 is a single formula. It's a Query that produces this table, called a Pivot Table.
As you add more data, including more Selectors if applicable, the table will grow automatically.
Query is a type of database function. In this case, it returns the count of the items, grouping the count by Selector and by Result. Query supports the Pivot Table function, which returns the result in the familiar down and across style report. Sheets also has a Pivot Table tool, but this is just a Query / PT.
EDIT
The formula is currently drawing from D10:F29. To insure that the formula continues to "see" new data, be sure to insert new rows within that range, or more precisely, "before" the last row of the existing reference. As you insert new rows, the reference will expand: D10:F30, then F31 etc. But if you insert rows on the sheet outside the existing reference, the formula won't know about it.
Best
Lance
When you've received a response that answers your question, please observe these forum courtesies;
• Leave your demo sheet shared as part of this solution's archive,
• Click Recommend on the post that best addressed your question, and
• Post again soon!
Last edited Jan 26, 2022
Original Poster John Izzard marked this as an answer
All Replies (5)
Jan 25, 2022
Hello John izzard,
I can be more accurate on a shared sample sheet. Also, you have Lose, and Place - but there is no samples for "Win" or "Void" in the data.
For now, delete all the labels and anything else in the range F34 to I and place this formula in F34:
=Query(D10:F29, "Select D, Count(D) Where D is not null Group by D Pivot F",0)The formula uses US syntax. I can't tell from a screenshot what locale you're working in.
Stock paragraph:
If you'd like help entered directly on a Google Sheet, from me or dozens of other forum contributors, please create a sample sheet we can all work on. This Blank Sheet Maker will help you share safely. Learn More: Google Product Experts' TIPS FOR POSTING
Best
Lance
When you've received a response that answers your question, please observe these forum courtesies;
• Leave your demo sheet shared as part of this solution's archive,
• Click Recommend on the post that best addressed your question, and
• Post again soon!
Last edited Jan 25, 2022
Jan 26, 2022
Will it continue to add up as it is a ongoing spreadsheet
Thanks
John
In cell F34 is a single formula. It's a Query that produces this table, called a Pivot Table.
As you add more data, including more Selectors if applicable, the table will grow automatically.
Query is a type of database function. In this case, it returns the count of the items, grouping the count by Selector and by Result. Query supports the Pivot Table function, which returns the result in the familiar down and across style report. Sheets also has a Pivot Table tool, but this is just a Query / PT.
EDIT
The formula is currently drawing from D10:F29. To insure that the formula continues to "see" new data, be sure to insert new rows within that range, or more precisely, "before" the last row of the existing reference. As you insert new rows, the reference will expand: D10:F30, then F31 etc. But if you insert rows on the sheet outside the existing reference, the formula won't know about it.
Best
Lance
When you've received a response that answers your question, please observe these forum courtesies;
• Leave your demo sheet shared as part of this solution's archive,
• Click Recommend on the post that best addressed your question, and
• Post again soon!
Last edited Jan 26, 2022
Original Poster John Izzard marked this as an answer