On Admin_Panel I have column E with a dollar figure applied. I need the Calander sheet to look at each row and determine if a community is serviced on Monday/what route/and what tech. Take all that match and add the dollar figurer. The sun should be displayed on the Calander sheet on D7.
I need this to be done for all days on all routes.
check attachment below.
Weekley_Planner.xlsm
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
The formulas that are there are fine. I need a separate formula to catch the details of the dollar figure. Column E on admin panel has the dollar figure. Each row has a day and route and is assigned to an employee. I need the formula that will look at each of those items and if an account is a match for day/route then the column E numbers are added up or summed up and the final number is placed into for example D7 on Calander sheet.
The formula will drop the number into D7 id it matches Monday route1.
In D7 on Calander sheet:
Formula:
Please Login or Register to view this content.
Copy And paste to the other cells needing the formula
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
this is what I needed. I have one more thing on this sheet and I will be done with it for programing. Thank you dredwolf. I appreciate your help greatly.
You are welcome
This one was pretty easy compared to the last one tho...lol
Thought you had a doozy coming
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks