Adding selected cells
 

If i have a list of numbers say in cells c1 to c10 and i have a sum to
add these all together and display the answer in c11. I want to be able
to only allow the cells (c1 to c10) which have been allowed to be part
of the sum by entering a figure in d1 to d10 i.e if c2 contains £20 it
cannot be added until d2 has a figure in it. Any help would be great.


--
alanled
------------------------------------------------------------------------
alanled's Profile: http://www.excelforum.com/member.php...o&userid=30949
View this thread: http://www.excelforum.com/showthread...hreadid=508780

Adding selected cells
 

Use SUMIF

For example,

=SUMIF(D1:D10,"<",C1:C10)

Regards

Trevor


"alanled" wrote in
message ...

If i have a list of numbers say in cells c1 to c10 and i have a sum to
add these all together and display the answer in c11. I want to be able
to only allow the cells (c1 to c10) which have been allowed to be part
of the sum by entering a figure in d1 to d10 i.e if c2 contains £20 it
cannot be added until d2 has a figure in it. Any help would be great.


--
alanled
------------------------------------------------------------------------
alanled's Profile:
http://www.excelforum.com/member.php...o&userid=30949
View this thread: http://www.excelforum.com/showthread...hreadid=508780