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     www.energyefficientbuild.com.   May-12-2014
post by: Hamza kamal  (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/SLwuXPkbteo)
Using COUNT function with Vlookup.
Hi,

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.

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


No comments:

Post a Comment