software

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: www.excelforum.com/member.php...oamp;userid=30949
View this thread: www.excelforum.com/showthread...hreadid=508780Use SUMIF

For example,

=SUMIF(D110,quot;lt;gt;quot;,C1:C10)

Regards

Trevorquot;alanledquot; gt; wrote in
message ...
gt;
gt; If i have a list of numbers say in cells c1 to c10 and i have a sum to
gt; add these all together and display the answer in c11. I want to be able
gt; to only allow the cells (c1 to c10) which have been allowed to be part
gt; of the sum by entering a figure in d1 to d10 i.e if c2 contains £20 it
gt; cannot be added until d2 has a figure in it. Any help would be great.
gt;
gt;
gt; --
gt; alanled
gt; ------------------------------------------------------------------------
gt; alanled's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30949
gt; View this thread: www.excelforum.com/showthread...hreadid=508780
gt;