Assuming you are using columns A, B and C here, then you can use:

=SUMIF(B:B,"HH1",C:C)

Hope this helps.

Pete

On Jan 3, 12:57*pm, Tauqeer M.Latif
wrote:
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.