In DATABASE criteria "Blank Cell" AND ="" are NOT the same things?? I couldn't find any solution to this simple point yet !
As known, when criteria cell is EMPTY excel IGNOREs that Criteria.
BUT, the problem is;
- If criteria cell is really BLANK, excel really (totally) ignores that criteria
- If criteria cell is BLANK with FORMULA (as ="" ), then excel ignores that criteria again, BUT this time NOT COUNTING "the ROWS with blank cells" in database table.
(As seen clearly at attached file)
Problem is a simple point, but solution is not found yet:
According to Excel's reading, the Difference Between "Blank Cell" & "Null Text" is causing this problem in Criteria Cell.
I am looking for any excel expression which TELLS to Excel to read that Cell as "Blank Cell"
Is there any way to do it?
Which version of excel you
Which version of excel you are using , i tried it on excel 2010 and criteria cell blank with fomuala (as=") work totally fine for me ?
Use SUMPRODUCT instead of DSUM
=SUMPRODUCT((B3:B7<>"")*(C3:C7))
In DATABASE criteria "Blank Cell" AND ="" are NOT the same thing
First of all, I like to know if the cell with "Null Text" is the result of a formula or not.
If it's not a formula, then you can delete the content of that cell, so it becomes a "Blank Cell".
If it's the result of a formula, then the only option I can see is to write a macro. This macro can be one for making the sum automaticly, or one for filling the empty cells in the database table with an empty string.
I can help you with this macro, if necessary.
Greetings,
Cheetahke