Thread
:
Sum of random cells with positive data
View Single Post
#
3
JulieD
Posts: n/a
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?
Reply With Quote