View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] affiliateian@gmail.com is offline
external usenet poster
 
Posts: 3
Default Only adding up specific categories

I was wondering if there is a simple way to do this.

1. Column A & B are both categories so for example Office Cleaning
could be in either columns
2. Column C are the associated dollar values
3. Only add up cells in Column C is "Office Cleaning" is either in
Column A or B

Is this possible?