View Single Post
  #3   Report Post  
JulieD
 
Posts: n/a
Default

Hi Susannah

use the SUMIF function
e.g.
=SUMIF(A1:A5,"0")

Cheers
JulieD

"Susannah" wrote in message
...
How do I sum numbers from random cells (in other words they are not
sequential or patterned) only if the cells contain positive numbers?