SUM the column, IF...

  • Thread starter Thread starter Tauqeer M.Latif
  • Start date Start date
T

Tauqeer M.Latif

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
 
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.
 
Back
Top