Wednesday, September 12, 2012

yogi_Using DCOUNT With The Criteria Cell Being Empty (Blank)

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #743   Sep 12, 2012

user xpegenaute said: (!category-topic/docs/spreadsheets/I-XrCrxh-LU)
DCOUNT: 2ndCritera the cell must be empty, is it possible?
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.
Activity MemberNumber
Dinner ????
MemberNumber Activity
5 Dinner
2 Breakfast
3 Breakfast
7 Dinner
following is a solution to the problem:

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