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.