Excel - sum items from one column based on search from different column I create

ID: 3565455 • Letter: E

Question

Excel - sum items from one column based on search from different column

I created a spreadsheet with figures in column D and a category description in column F.

I want to sum the figures in column D based on the category in column F.

So I want to total all the items fromm column F that have the same category, example:

Column D range is D1:D161 with various figures and column F range is the same deescribing what category it belongs to

D1 = $100 F1 = Insurance

D2 = $50 F2 = Gas

D3 = $75 F3 = Housing

D4 = $200 F4 = Insurance

So I want to total up how much is in each cell in coluumn D for each category.

I don't want the category in ccolumn A, I have something else in that column.

I figured out my own formula to make it calcculate the way I want it to worrk.

I used sumproduct with my amounts in column D and the category in column F and my list of categories further down starting in A166.

=sumproduct(($f$1:$F$162=A166)*($D$1:$D$162))

This worked the wway I wanted it to go....

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.