one_more_cave_dweller
Board Regular
- Joined
- Sep 27, 2004
- Messages
- 118
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: