summing numbers based on 2nd column

[Guest]

I have a worksheet that has 2 columns A, B. there are numbers in each
column. What I want to do is sum only the numbers in column A that have a
number greater than 0. ie a1 has 10 and b1 has 1, a2 has 8, b2 has 0 a3 has
7 and b3 has 1. Now I should get 17 when I sum the A column because b2 is 0
so a2 wouldn't be counted. I'm using excel 2002 sp2.

 

[daddylonglegs]

Try

=SUMIF(B:B,">0",A:A)

 

[Guest]

Try this:

=SUMIF(B:B,">0",A:A)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Thanks, that worked great. Just what I needed.

Try this:

=SUMIF(B:B,">0",A:A)

Does that help?
***********
Regards,
Ron

XL2002, WinXP