sum items in a table based on description

  • Thread starter Thread starter Hrider
  • Start date Start date
H

Hrider

I am interested in summing items is a table based on their description. Is
there a formula that will add items together from column based on the
contents in another cell reference in the same row? I know a pivot table
will do this with some restrictions in the table design.
 
You can use sumif if there is onbly one condition

Assume you want to sum values in column
C where column B is "x"


=SUMIF(B2:B500,"x",C2:C500)

Regards,

Peo Sjoblom
 
Back
Top