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 #	publication	started	done			Complete
item1	pub1	1/1/2014	1/5/2014			pub1	2
item2	pub1	1/2/2014				pub2
item3	pub2	1/5/2014	1/7/2014			pub3
item4	pub1	1/1/2014	1/7/2014			pub4
item5	pub5	1/1/2014				pub5
item6	pub4
item7	pub3

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