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   Oct 30, 2013
question by Lancertech SJDLSchool(!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.