Tuesday, September 23, 2014

Formula In Cell J2 For Cells J2 To J For Row By Row Comma Delimited List Of Days Off By Each Name In Column A

                     Google Spreadsheet   Post  #1768
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-23-2014
post by  googledocsfan:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/4_Xx8Twztao)
Creating a formula to return 'Days OFF'. Help :) Spreadsheet Included!
Hello all!  I would greatly appreciate your help in figuring this out.  Please see the attached below.  
I have a chart showing days off for a list of names. In Column J, this is my desired result that I am trying to produce (without manually doing it).  Does anyone have a formula or solution to make this work in google sheets?
The results don't have to be formatted exactly like shown, but something similar would work.  Thank you so much for any of your help!  

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