With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, September 12, 2012
yogi_Using DCOUNT With The Criteria Cell Being Empty (Blank)
I am having this little example with two columns, I want to know how many dinners I need to cook for people who are not member of my group. I thought to do it with DCOUNT, but I don't know how to deal with the empty "MemberNumber" and DCOUNT.
the spreadsheet underlying this post as of Sep-13-2012 is suffering from server error occurritis ... and I am not sure when it will come back to life -- so I have presented essentially the same (but not identical) solution in the following blog post:
yogi_Using DCOUNT With The Criteria Cell Being Empty (Blank) Spreadsheet No 2