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!