G Guest Nov 22, 2004 #1 I do not want to calculate minus in my totals so how can I use the sumif function with non consequent cells.
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 Nov 22, 2004 #2 Hi you may provide some more info about your data layout. Maybe you mean =SUMIF(A1:A100,"<0")
