Formula for SUM by the category
Unfortunately couldn't find the solution here.
I'm just looking for a formula that will allow me to count total sum by the category of a product.
Basically, I have two columns: first is the Dropdown list with the category of a product, and second one is the Text/number column with the bid amount. What I need is a total sum based on each category. Is there a formula or some other way to solve this problem? I really appreciate any help. Thank you in advance!
Comments
-
Have you tried the sumifs function? you would need 1 for each category.
-
I also used the SUMIF or SUMIFS function for this issue. Be aware that the syntax for these two formulas are different.
-
I apologize in advance if I miss some obvious things, I'm very new to smartsheet. It just that I logically can't really understand how I build the formula when I have a product name in one column and bid in another column, taking into account that bid number is always different. Using SUMIF I see how I can do it for each product separately if it always would have the same bid amount. I'm probably just missing something. I really appreciate your help and patience!
-
Hi! Thanks for the hint, I'm not sure how can I properly built such formula in my case, I gave more details in my reply to the first comment. Thanks a lot for your help!
-
How about something along these lines:
=SUMIFS([Bid Number]$1:[Bid Number]$10, [Product Name]$1:[Product Name]$10, [Product Name]13)
-
This is exactly what I'm looking for! Can't express how thankful I am. You are the best, thank you one more time.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!