Forum Discussion

MTooba's avatar
MTooba
Brass Contributor
Nov 11, 2020
Solved

How to aggregate the drop down list items to get the category-wise sum?

Hi,   Please see the attached file. I am trying to calculate the costs in terms of categories (services) from drop down lists. Sheet 3 is the final sheet to show the calculated results based on the...
admin
BI & Data Analysis
Charting
developer
excel
Excel for web
Excel on Mac
Excel on mobile
Formulas and Functions
Macros and VBA
  • mtarler's avatar
    mtarler
    Nov 11, 2020

    MTooba in the attached I did what I think you want in 2 different ways:

    a) pivot table - this is powerful and flexible solution

    b) formula:

    =SUMIF(Sheet2!F:F,C6:C10,Sheet2!H:H)

    if the array formula above doesn't work then replace C6:C10 with just C6 and copy it down the column

mtarler's avatar
mtarler
Silver Contributor
Nov 11, 2020

MTooba in the attached I did what I think you want in 2 different ways:

a) pivot table - this is powerful and flexible solution

b) formula:

=SUMIF(Sheet2!F:F,C6:C10,Sheet2!H:H)

if the array formula above doesn't work then replace C6:C10 with just C6 and copy it down the column

MTooba's avatar
MTooba
Brass Contributor
Nov 11, 2020
Thank you very much. It is really helpful. The formula with C6:C10 works well.

Resources