CODEWITHSUNDEEP
excelgoogle-sheets
Cosmic Hawk
Cosmic Hawk

Reputation: 217

How do I sum up the value of a column where a given value exists in another column?

Each row in my sheet represents a transaction. One column (G) contains the client name and another column (H) contains the GP from the exchange.

I'm trying to make a report in another sheet that references these cells to get GP info for each of our clients.

The formula I'm trying to accomplish is this: Sum up the GP (column H) from every row containing [ClientID] in Column G

The ClientID is on Column G and GP is on Column H

I would like to make this process automated so that each time a transaction is entered, the Client GP sheet will be automatically updated.

Thanks.

Upvotes: 0

Views: 101

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

Only so this can be closed out:

As per my comments use the SUMIF() function:

=SUMIF(G:G,[ClientID],H:H)

References: GOOGLE and EXCEL

Upvotes: 1

Related Questions