Excel if function

K

kim

I do not want to calculate minus in my totals so how can I use the sumif
function with non consequent cells.
 
F

Frank Kabel

Hi
you may provide some more info about your data layout. Maybe you mean
=SUMIF(A1:A100,"<0")
 
Top