Wednesday, October 30, 2013

yogi_Count The Number Of Students By Type of Lunch Desired On A Specified Date

                                          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
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.

--------------------------------------------------------------------------------------------------------------------