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