Add the value of one cell only if another cell has a certain #

Closed
Report
Posts
1
Registration date
Sunday July 10, 2016
Status
Member
Last seen
July 10, 2016
-
Hi everyone.

I'm trying to make a spreadsheet to categorize business expenses into IRS categories.

For example Column C has the cost for each expense and column E has the corresponding code. In this case Code 9 is for insurance payments, Code 12 is for mortgage payments.



I would like to be able to make a summary of the various codes and the total amounts for those categories expenses throughout the year.

Any guidance is greatly appreciated.