index,match and sum question

[wj_clark]

On one sheet(TX Sheet) I have date, transaction, transaction category( for ex. groceries)and amount. On another monthly budget sheet, I have column A =Categories, Column B = budget amount and want actuals in column c. I want to write an equation that allows me to find and sum all grocery transactions, all utilities transactions, all entertainment transactions etc from the TX sheet and put the sum of the individual transaction into the appropriate category on the Budget sheet.

[rylo]

Hi

Try the SUMPRODUCT function.

There are a heap of examples on the site so do a search and see if you can work out something from there.


rylo