Thank you both, so much. I appreciate your help.
Bernie


"bw" <iamnu@cableone.net> wrote in message
news:12060mofq6cef5c@corp.supernews.com...
>I would like to have a formula in a single cell that will sum the values in
>range E:E if the corresponding value in G:G is >0.
>
> for example:
> Col G Col E
> 5 1
> 0 8
> 9 3
> 0 7
>
> The sum of Col E is 4.
>
> Thanks,
> Bernie
>