Thread: SUM the column, IF...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tauqeer M.Latif Tauqeer M.Latif is offline
external usenet poster
  
Posts: 1
Default SUM the column, IF...
Here is my data:

Data1 Data2 Data 4
combiner HH1 5
splitter HH2 6
combiner HH1 5
splitter HH2 6
combiner HH1 5
splitter HH2 6

I want to add all the data from column "Data 4", If the corresponding row
contains "HH1".

Thanks.
Reply With QuoteReply With Quote