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 / December 2007

Tip: Looking for answers? Try searching our database.

DSUM with empty cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joseph N. - 21 Dec 2007 16:00 GMT
I just noticed that a DSUM function I was using is not working
properly because the criteria includes an empty cell and the function
is not picking up an empty cell as meaning that the criterion is an
empty cell.

Sheet A has:
=DSUM(A:H,"Charge",B!A2:B3)

Sheet B has:
Payable      Date Pd
y

In other words, the cell under "Date Pd" is blank, because the
criteria are that there is a 'y' in the payable column and nothing in
the Date Pd column.  However, the DSUM function is not picking up the
blank cell.  It works if I use 't' and 'f' or other logical terms, but
not 'blank' and 'not blank.'

Is there a way to make the function recognize a blank cell?

[Excel 2003]
Peo Sjoblom - 21 Dec 2007 18:10 GMT
Remove the header in B2 and in B3 put

=Sheet2!B2=""

where Sheet2!B2 is the first cell with data in the Date Pd column

Signature

Regards,

Peo Sjoblom

>I just noticed that a DSUM function I was using is not working
> properly because the criteria includes an empty cell and the function
[quoted text clipped - 17 lines]
>
> [Excel 2003]
 
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.