How to find if the cell is emty or contains value

[Mosaddeq Aziz]

Dear All,

I need a solution to the following problem. I have two columns of values. I
need to find the subtraction of the sum of two column. I can do it maually
by entering the range. What i need is solution that will scan each scan
untill the cell is empty, sum the cells of two column and then subtract the
sum of one column to the other. Thanks in advance.

best regards,

Mosaddeq Aziz

 

[MartinW]

Hi Mosaddeq,

Try =SUM(A:A)-SUM(B:B)

HTH
Martin

 

[Mosaddeq Aziz]

Hi Martin,

Serves the purpose. thanks.

M

Hi Mosaddeq,

Try =SUM(A:A)-SUM(B:B)

HTH
Martin