Sum Values depending on other values

[bw]

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

 

[Bob Phillips]

=SUMIF(G:G,">0",E:E)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Try this:

=SUMIF(G:G,">0",E:E)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[bw]

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