How to um a column with different values
I am trying to sum the product category column that has 4 different values...the goal would the sheet look like
Access Solutions 2023 - ?# 2024 - #
Retail
Shop Solutions
I have been struggling to write a formula on this...please help
Best Answer
-
HI @EdBo ,
I'm not sure where you want the values to appear based on your screenshot, but you can use the COUNTIF function to count the number of occurrences based on the range. Depending on where you want to use the formula, you would create one for each option in the drop down:
=COUNTIF([Product Category]:[Product Category], "Retail Solutions (Carts)")
=COUNTIF([Product Category]:[Product Category], "Shop Solutions").. etc
Otherwise, depending on how you want to use the information (perhaps in a dashboard or a report), you could count the number of instances using filters on a report or a metric widget on a dashboard - and there might be no need for a formula on your sheet.
What is your desired outcome? If you could tell us why you want to sum the number of instances for this category and how you want that information to be used, the Community can probably provide you a better solution.
Thanks,
Justin
Answers
-
HI @EdBo ,
I'm not sure where you want the values to appear based on your screenshot, but you can use the COUNTIF function to count the number of occurrences based on the range. Depending on where you want to use the formula, you would create one for each option in the drop down:
=COUNTIF([Product Category]:[Product Category], "Retail Solutions (Carts)")
=COUNTIF([Product Category]:[Product Category], "Shop Solutions").. etc
Otherwise, depending on how you want to use the information (perhaps in a dashboard or a report), you could count the number of instances using filters on a report or a metric widget on a dashboard - and there might be no need for a formula on your sheet.
What is your desired outcome? If you could tell us why you want to sum the number of instances for this category and how you want that information to be used, the Community can probably provide you a better solution.
Thanks,
Justin
-
That worked Perfectly
Thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!