Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

How to find if the cell is emty or contains value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mosaddeq Aziz - 07 Jun 2007 09:32 GMT
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 - 07 Jun 2007 10:26 GMT
Hi Mosaddeq,

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

HTH
Martin

> Dear All,
>
[quoted text clipped - 7 lines]
>
> Mosaddeq Aziz
Mosaddeq Aziz - 08 Jun 2007 13:07 GMT
Hi Martin,

Serves the purpose. thanks.

M

> Hi Mosaddeq,
>
[quoted text clipped - 14 lines]
>>
>> Mosaddeq Aziz

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.