# Sum Amount based on Multiple Criteria

1. ## Sum Amount based on Multiple Criteria

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

2. ## Re: Sum Amount based on Multiple Criteria

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.

3. ## Re: Sum Amount based on Multiple Criteria

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

4. ## Re: Sum Amount based on Multiple Criteria

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

See the attached file.

5. ## Re: Sum Amount based on Multiple Criteria

Thanks for the rep.

Thanks for marking the question solved.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1