Sumif and ignore negative numbers...

[springerwa]

I have tried a few options that I have found on the boards but I have not been successful...

My existing formula is working but I have now realized that there is sometimes negative numbers in the S - X columns and I need to ignore them.

My existing formula:
=SUMIF('Sales Orders Summary'!$D$5:$D$117,$A10,'Sales Orders Summary'!$S$5:$S$117)+SUMIF('Sales Orders Summary'!$D$5:$D$117,$A10,'Sales Orders Summary'!$T$5:$T$117)+SUMIF('Sales Orders Summary'!$D$5:$D$117,$A10,'Sales Orders Summary'!$U$5:$U$117)+SUMIF('Sales Orders Summary'!$D$5:$D$117,$A10,'Sales Orders Summary'!$V$5:$V$117)+SUMIF('Sales Orders Summary'!$D$5:$D$117,$A10,'Sales Orders Summary'!$W$5:$W$117)+SUMIF('Sales Orders Summary'!$D$5:$D$117,$A10,'Sales Orders Summary'!$X$5:$X$117)

Can I get a suggestion on how to not calculate the negative values? And if there is an easier way to do this...that suggestion would be welcome also.

Thanks!

 

[Domenic]

Try...

=SUM(IF('Sales Orders Summary'!$D$5:$D$117=$A10,IF('Sales Orders Summary'!$S$5:$X$117>0,'Sales Orders Summary'!$S$5:$X$117)))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

 

[springerwa]

Thank you so much! I should have given in about 6 hours sooner than I did

I have saved this one in my reference list I compile along my travels of solutions to borrow from some day when another problem arises.

K