Add cells in a column where other cells equal a value

's Computer Specifications

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

's Computer Specifications

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)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

's Computer Specifications

Thanks for that. Really appreciate it.

C

's Computer Specifications

Colin Weir wrote :
> Thanks for that. Really appreciate it.
>
> C

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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I make a range of cells in a column equal to another cell	jggsfl	Microsoft Excel New Users	1	21st Dec 2007 01:15 AM
Sum column based on value in each row, if two cells equal, or if date is within time period	clynneo@hotmail.com	Microsoft Excel Worksheet Functions	8	25th Sep 2006 02:40 PM
Need to sum a column if two cells in row are equal	cynthiaorser@houston.rr.com	Microsoft Excel Worksheet Functions	1	24th Sep 2006 05:36 PM
all long column of cells equal to whatever I put in B2		Microsoft Excel Discussion	3	9th Jun 2005 04:16 AM
Add Cells In A Column Until They Equal 4200	Steve Roberts	Microsoft Excel Programming	2	18th Apr 2005 03:06 AM