Share via

Sum of Values Related to a drop down list

Anonymous
2016-03-04T12:55:07+00:00

I'm working on a sheet which tracks an itemized marketing budget spend across multiple brands.

In one column I have a drop down list by brand. In the column next to it is a value of how much was spent in a given time for that specific brand.

In the example below, in column G I want a formula which adds the amount spent in column C per each brand in Column B.

Help please!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2016-03-04T13:51:45+00:00

    Hi,

    in cell G4 write:

    =SUMPRODUCT(($B$4:$B$15=$F4)*$C$4:$C$15)

    and copy down up to G10

    1 person found this answer helpful.
    0 comments
Answer accepted by question author
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2016-03-04T23:53:26+00:00

    Hi,

    One simple way would be to build a Pivot Table.  Just drag Brand to the Row labels and Cost to the value area section.

    If you prefer a formula, then enter this formula in cell G4 and copy down

    =SUMIF($B$4:$B$15,F4,$C$4:$C$15)

    Hope this helps.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest