Add cells in a column where other cells equal a value

  • Thread starter Thread starter Colin Weir
  • Start date Start date
C

Colin Weir

Hi There

I'm looking to add up a column of cells, say column K, but I only want it to take into account the cell in column K where the corresponging cell in column C equal a particular value, "SLC". Is this possible? Hope this makes sense.

Thanks

Colin
 
Colin Weir brought next idea :
Hi There

I'm looking to add up a column of cells, say column K, but I only want it to
take into account the cell in column K where the corresponging cell in column
C equal a particular value, "SLC". Is this possible? Hope this makes sense.

Thanks

Colin
Click to expand...

Try...

=SUMIF($C:$C,"SLC",$K:$K)
 
Back
Top