Formula for SUM by the category

Y. Czerski

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! 

PGreene

Have you tried the sumifs function? you would need 1 for each category. 

Steve DeAses

I also used the SUMIF or SUMIFS function for this issue. Be aware that the syntax for these two formulas are different.

Y. Czerski

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!   

Y. Czerski

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! 

PGreene

How about something along these lines: 

=SUMIFS([Bid Number]$1:[Bid Number]$10, [Product Name]$1:[Product Name]$10, [Product Name]13)

 

Y. Czerski

This is exactly what I'm looking for! Can't express how thankful I am. You are the best, thank you one more time.