Hi guys, So im looking for a formula but i don't know how to go about it.
So a formula in F16 to look up B16, on sheet "TOP 15 WORST OFFENDERS" For the ID In Column C Then look in column E and add together all the numbers that come up making sure it corresponds with the name in column C, but the name might come up like 5000 times with different times in column E? I've Attached a worksheet to show kind of what i mean.
"TOP 15 WORST OFFENDERS" Sheet can have up to 600,000 bits of data
thanks
Formula for B16
=SUMIF('TOP 15 WORST OFFENDERS'!C:C,Summary!B16,'TOP 15 WORST OFFENDERS'!E:E)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks it worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks