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.

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.

Hi,

FYI - you can make formulas more flexible by using cell references, so in
this case your formula could read

=SUMIF(B2:B10,F1,C2:C10)

where F1 contains the entry you want to sum for - HH1.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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.