Hi, Wondering if any help out there for following problem:
I have six cells with dates in four and blanks in two cells, all in one workbook which I need to link to another workbook but it needs to go in to a single cell with the dates added up and the blanks ignored. For example, six cells with dates in four cells and two with blanks would link over to the destination workbook and into a single cell as the number 4 (blanks not added up). I just don't know how to do this!
maybe something like this:
Formula:
Please Login or Register to view this content.
obviously not tested, but the Idea is correct for your description of it in OP
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
thanks dredwolf. I will try this and see how it goes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks