View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Colin is offline
external usenet poster
 
Posts: 86
Default Sum of cells under a condition

I have data in the range A1:K2000. In column C I have descriptions for
different types of business expense. In column G I have the amounts of these
expenses.
I want a formula that searches column C for a specific business expense and
when finding it, adds up all the related values in column G.

How do I do this?
--
Thank you,

Colin.