Hi all,

I need to calculate in the H6 cell the number of orders in which the postcode is not available, by using the DCOUNTA database function. I got a task to use DCOUNTA and not a COUNTBLANK function...
In criterion I may either use the ISBLANK function or look for the text with a zero length by using the LEN function.


Please help...

File attached.

addresses.xlsx