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.

Use SUMIF

For example,

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

Regards

Trevor


"alanled" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>