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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!