SUMIF based on cell value >0

[ChrisClab]

hi, all -

I'm attempting to set up a SUMIF criteria based on a range of cells
but only want to sum the cells that have a value >0. Does anyone kno
of a method that will enable me to accomplish this? Is SUMIF the wron
function to be using?

Thanks in advance.

ChrisCla

 

[Frank Kabel]

Hi
if you want to sum column A try
=SUMIF(A:A,">0")

 

[Don Guillett]

try
=SUMIF(C1:C5,">0")