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!

Find more posts tagged with

Sales

Formulas

Project Management

Comments

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)

Sumifs demo1.JPG

Sumifs demo2.JPG

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Combining a few columns into one --can I nest IF statements?
My current formula is =IF([To whom will the sample go?]@row = "Customer/Shipped out", "Shipping Date: " + [Date to be Shipped]@row + CHAR(10) + [Ship Method]@row + CHAR(10) + CHAR(10) + [TR Full Contact Info]@row , "") I need this to be able to look at [TR Full Contact Info]@row and if blank, pull the information from [IN…
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
Match or Index
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)