Problem with formula

[one_more_cave_dweller]

I want cell a20 to return the value of cells c1:c10 but only if cells d1:d10 contain a value. I tried =SUMIF(d$1:$d$10,">0",$c$1:$c$10) but that will not work if d1:d10 contains a negative number. I also tried =SUMIF(d$1:$d$10,"<>0",$c$1:$c$10) but that returns values from a1:a10 and b1:b10 also. How can I get it to pick up either positive or negative numbers for only c1:c10?

Thanks ray:

 

[vconfused]

So, as long as there is a number in any cell from D1 to D10, then we want to sum whatever is in C1 through C10?

Or do we only want to sum the numbers in C1 throuth C10 only if there is something in the same row in D10?

 

[Tazguy37]

Maybe this?:
=SUMIF(D$1:$D$10,"<>",$C$1:$C$10)

Hope that helps!

 

[vconfused]

If the latter, then you could use:

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

 

[one_more_cave_dweller]

Thanks again TAZ!!!