Saturday, February 15, 2014

yogi_Compute Instances Of Completions For Each Of The Publications From Table Of Publications And Completion Dates

                                         Google Spreadsheet   Post  #1531
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-15-2014
post by emily thebeau (https://productforums.google.com/forum/#!topicsearchin/docs/Hyde%7Csort:date%7Cspell:true/docs/0igPzExXCI8
counting multiple cells based on text and dates
Hello!  I would appreciate some help with something I am working on.

I need to have a formula that will look at items in publications based on publication names and then count them if a date is entered into a "done" column.
something like this:


item #publicationstarteddoneComplete
item1pub11/1/20141/5/2014pub12
item2pub11/2/2014pub2
item3pub21/5/20141/7/2014pub3
item4pub11/1/20141/7/2014pub4
item5pub51/1/2014pub5
item6pub4
item7pub3

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