Google Spreadsheet Post #1404
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Oct 30, 2013
question by Lancertech SJDLSchool(http://productforums.google.com/forum/?zx=2rjy30tg356g#!category-topic/docs/spreadsheets/YdJbfaHeOYs)
Count number of entries for a specific day
--------------------------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Oct 30, 2013
question by Lancertech SJDLSchool(http://productforums.google.com/forum/?zx=2rjy30tg356g#!category-topic/docs/spreadsheets/YdJbfaHeOYs)
Count number of entries for a specific day
We are trying desperately to generate a lunch count that will only count the specific entries for the current day. The screen shot has a formula of =if(B2:B=today(),count(C2:C, counta("Hot Lunch")),0) which is returning a 0 instead of 2 for the Daily Hot Lunch Total. Please let me know what I am doing wrong or if there are any suggestions that will work better.
No comments:
Post a Comment