Sum based on range values

  • Thread starter Thread starter IC
  • Start date Start date
I

IC

I need to sum a column A, but only if values in an adjacent column B>0.

Therefore the example below should sum to 10 (only including the first 3
rows).

A B
7 5
0 4
3 9
0 0
0 0
0 0
8 0
0 0
0 0

Ideally this should be a formula in a cell, not a macro.

Any ideas? It doesn't sound complicated, but I can't get my head round it.

TIA

Ian
 
Thanks Julie. I knew it had to be straightforward. Just a case of knowing
which function to use.

Ian
 
Back
Top