computing
  • 4

Excel Drop Down List Sum Up

  • 4

I don’t know how to do the following:

I created a drop down list using validation function. the list is about categories of expenses (ie food, petrol etc). I have another column with amount in the same row.
Now at the end of the sheet I want to have a ‘total’ cell, where it sums up all the amount from a given category (so all food expenses are sum up in one cell).

I would really appreciate your help!

Share

1 Answer

  1. This is what worked for me…

    =SUMIF(D2:D20;”Petrol”;C2:C20)

    I will break it down in to parts:
    =SUMIF function command
    (D2:D20) is the cell range that you select for your catergory (petrol, food, etc)
    “Petrol” is the catergory you are adding up (if you are adding food, type in food instead of petrol)
    C2:C20 is the range of you price/amount

    Hope this helps!

    • 0