Last question for a while, promise...
As seen in the attachment, I'm looking for a formula that counts the days of the week for specific services and locations.
Any and all help is greatly appreciated.
Thanks again,
Brian
Last question for a while, promise...
As seen in the attachment, I'm looking for a formula that counts the days of the week for specific services and locations.
Any and all help is greatly appreciated.
Thanks again,
Brian
The simplest way is to use a helper column with the weekday number in it, then do a countifs with the weekdays and service as the criteria. It may be able to be done with an array formula without the helper column, but I am not yet an expert on those.
Hi ,
I had made some necessary changes to match your requirement.
Punnam
Find the solution in the attached workbook. This is what gak67 suggested.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Thanks for the replies...I added another wrench in my problem and I need to incorporate multiple service types (as seen in the attachment).
Per gak67, I added a helper column, but I haven't had any success with a formula to accurately count the number of services by day of the week.
Last edited by bdpate09; 05-27-2014 at 09:06 AM.
Can anyone help me out with the above formula? I can't seem to get it to count right.
hi bdpate,
take reference of my post 3 & brief me what is problem.
Punnam
Hi bdpate09
attached workbook as per your requirement
Hi Brian,
I've generalized the formulas coded by Raysrains. Find enclosed the updated workbook.
With an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks