Hi,
I am looking to find away to evenly spread costs over multiple lines based on 2 pieces of criteria.
In the attached example I have $1m and want to look up the project number in a list and find all IDs associated then look up the status' and spread the $1m over all Ids which are noted as Active, not allocating the costs to any cancelled.
Any advice or help with this is appreciated.
Thanks
Are you still only using EXCEL version 2010?
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
This thread has been marked as solved - is it?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try in J4:
Not sure if TRIM is a 2010 formula
=IF(TRIM(I4)="Closed",0,INDEX($B$4:$B$8,MATCH(G4,$C$4:$C$8,0))/COUNTIFS($G$4:$G$8,$C$4,$I$4:$I$8,"Active"))
TRIM goes back to Excel 2007, according to the MS support page on it: https://support.microsoft.com/en-us/...c-9e5630b479f9
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks