LinkBack URL
About LinkBacks
I think you're going to need to re-iterate what you need to have happen based on your sample....
I think you're going to need to re-iterate what you need to have happen based on your sample....
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Originally Posted by NBVC
Sure, lets start at the front and work from there.
Columns A and B are meant to be people's names. Column G is meant to represent the date they got written up. If it's the current date, the date appears in black. If it's over 24 hours old, it appears in red. The status in Column S really has no bearing for this example, so we'll discard that for now.
Column N represents the team the employee belongs to. Column V addresses all of this information and lists the total amount of write ups for that team (In this case, Team Cash). From there Column W calculates a percentage of the TOTAL amount of write ups for the entire site. What I want Column X to do is Take the amount of write ups per team that are over 24 hours old and list that number in the appropriate cell (Team Cash should have 1), then calculate that percentage in Column Y (which the formula is already written).
I hope this clears things up a bit.
Try:
=SUMPRODUCT(--($N$2:$N$20=U2),--($G$2:$G$20>0),--(TODAY()-$G$2:$G$20>=1))
adjust ranges. Sumproduct doesn't accept entire ranges like N:N
Then copy down.
You're awesome. I just adjusted the range to 20,000 so I dont have to deal with it for a LONG time. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks