I have a spreadsheet with a lot of transactions that are categorized. I need to add the transaction amount for each category in another sheet.

For example, if column J is "Product X", sum up the transactions in the corresponding cells in column "C" and place it in Sheet 1 cell C3.

I hope this makes sense.

Thank you.