Hi,
I am trying to calculate ratios for clients who work at multiple sites. A cleint may work at 1 or 3 sites and I need a formula or macro which can calculate the percentage of time a client has spent on each site fairly quickly without having to write a formula for each client. I have attached a spreadsheet with the first 2 clients populated.
Can anyone help?
Put this formula in G2 (or row 2 of any other column) and copy down:
Formula:
=$E2/SUMIF($A:$A,$A2,$E:$E)
this works - brilliant and thank you
Try this formula:
=E2/SUMIFS(E1:E100,A1:A100,A2)
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.
Yeah it works for me but you should have marked it as solved as you get the proper solution.
Leave moderation to the moderators.Originally Posted by elija6266
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks