Monday, May 12, 2014

yogi_Compute Number Of Items Added And Completed Column By Column For Range Of Dates

                                         Google Spreadsheet   Post  #1636
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May-12-2014
post by: Hamza kamal  (!category-topic/docs/spreadsheets/SLwuXPkbteo)
Using COUNT function with Vlookup.

I'm trying to count the number of timestamps in Column D which correspond to a particular date.

In the "Tracking" sheet of the following Google Spreadsheet, I'm trying to populate Range C6:J6.

For example, I'd like cell I6 to reflect 8 because 8 out of the 17 companies added on May 9th have timestamps which reflect completion.