How to um a column with different values

EdBo

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

jprovo227

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

jprovo227

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

EdBo

That worked Perfectly

Thank you