Add cells in a column where other cells equal a value

[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

 

[GS]

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

Try...

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

 

[Colin Weir]

Thanks for that. Really appreciate it.

C

 

[GS]

Colin Weir wrote :

Thanks for that. Really appreciate it.

C

You're welcome, Colin! ..glad to help.