Drop down Cell calculation

Can anyone explain how to create a formula for adding up amounts from a specific cell that is a drop down? For example I have multiple clients that I can select from my drop down list. Each time there's a transaction from that specific client, I want to have the amount calculated in a separate column. How do I add the amount from each client from my drop down list to a separate cell that shows that clients total?

Find more posts tagged with

Comments

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

s.kinsman76601

What im using this for is basically a sales tracker. In one of the columns I have a drop down list of each client. What im looking to do is have a separate column set up so when the client does make a purchase, I can see the totals for each client.

Andrée Starå

Hi,

There are a few different ways to set this up. Either with a column with the clients in the top of the sheet or beside all other information or in another sheet with the help of cross-sheet formulas.

Try this.

Add a column called Client List where you list all your clients.

Client 1

Client 2

Client 3 and so on.

Add another column called Total Sales / Client and add the formula below. The formula will look at the Client List column in the same row and give you the total of that client.

=SUMIF(CLIENT:CLIENT; [Client List]@row; TOTAL:TOTAL)

The same version but with the below changes for your and others convenience.

=SUMIF(CLIENT:CLIENT, [Client List]@row, TOTAL:TOTAL)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Linking sheets - Trying to build off of information from other sheets
Hello! I am pretty new to the intricacies of the platform as I'm looking to lead some project management and automations for the organization I'm in. I have a sheet I am trying to build Automations into, but would like to see if anyone can walk me through how to link this information from other sheets, as they get updated.…
Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
Form Submittal Error
Hello, one of our users is getting this error when trying to submit to a form. Other users are able to submit to it without a problem.