subtract two collums only if value

Hello

I am looking for a way to subtract to collums.

In the first A there is always a value.

In the second B a value needs to be added.

When the second value is added I want collum B to substract from A.

Then I want the result of all to be given in a cell, not just B1-B2 but (B1:B50)-(A1:A50).

The thing is that if collum B is empty, I don't want that line to be counted.

Maybe it is a bit complicated.

I started with:

Please Login or Register  to view this content.

But I have 600 Lines

Can anyone help me

Try this formula

Formula:

Please Login or Register  to view this content.

You'll need to be careful with how you manage column B. If column B is empty.... has null values (blank), then the "<>0" will not return the correct answer. You will need to use something like this:

Please Login or Register  to view this content.

You can actually shorten this a bit to:

Please Login or Register  to view this content.

"<>" indicates that it is to sum all records that are not empty.