Sum Amount based on Multiple Criteria

[Fish55]

Hi,

I am looking to allocate a cost based on multiple criteria.

In the attached example I have $1m and want to allocate this to all ID's under the project number. However I want to only allocate to ID's which have a status of "Active" or "Still Active".

I am also looking at ways of splitting the $1m evenly to these ID's if possible.

Thanks

[oeldere]

I changed the lay out of the file.


K2=IF(ISERROR(MATCH($I4,$N$2:$N$8,0)),"",G4&" yes") and drag down

L2=IF(K4="","",VLOOKUP($G4,$B$4:$C$15,2,0)/COUNTIF($K$4:$K$8,K4)) and drag down

See the attached file.

[Fish55]

Thank you very much for your help.

I did have one other question if you wouldn't mind helping.

I was wondering what formula I would need to count all ID's with "Active" and "still active" status.

I am currently trying - =COUNTIFS(I:I,OR("Active","Still Active"))

But this is not working. Not sure what I am missing.

Thanks again

[oeldere]

M1=Countif($M$4:$M$9,"yes")

See the attached file.

[oeldere]

Thanks for the rep.

Glad I could help.

Thanks for marking the question solved.