Calcaulate multiple columns with In and Out quantities

[donna851990]

Hi

I have an excel sheet where I have different products in the rows and in each of the columns I have the quantity of a batch number. However, after every column with these quantities, I have another column with a minus and then another number. If we have no stock, then the minus number will match the number in the column before it and if there is stock left, the minus will be less that the positive.

Image.jpg

Is it possible that a formula can tell me if there are multiple columns where there is spare stock?

Thanks

[jeffreybrown]

Would this work for you?

=SUM(B3,D3,F3)+SUM(C3,E3,G3)

or if the columns were to expand beyond the three...

=SUMIF($B$1:$G$1,"IN",B3:G3)+SUMIF($B$1:$G$1,"OUT",B3:G3)

[Sam Capricci]

maybe =SUM(B3:G3)