View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KKD KKD is offline
external usenet poster
 
Posts: 31
Default Sum only specific cells based on value in adjacent cell

I want to have a cell that is calculating all costs in a particular category.
The data is laid out in rows, so I will have the following columns:

Date Vendor Category Amount

I want a cell that is adding all amounts that are listed as a particular
category. One category might be "Events", another "Operations", etc. I want
these totals to be separated per category.
--
KKD