Monday, March 31, 2014

yogi_Count The Number Of Persons Who Finished After 10:00 PM And Put The Count At End Of Entries In Column B

                                         Google Spreadsheet   Post  #1581
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-31-2014
post by SiP5002 (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/6p4Fc0XLKO0)
If time is above formula
Hi,

I would like to know how to do a formula that will total up the amount of people in a column that finish at 10pm or later and put the total at the bottom. Is anyone able to help me?

Thanks

Simon
-----------------------------------------------------------------------------------------------------------------------------------------------------
how exactly Simon wants to present the result is not clear ... so let me see if the following illustration will do