# SUMIF meets criteria in another column and divide by particular amounts

##### New Member
Hello all, I posted this elsewhere but wanted to try again to see if I got any other responses. I want to work out the cost per person.....here's some sample data so you can see what I mean.

Cost Split
10 ALL
20 ALL
30 AA
40 AB
10 ALL
20 AB
30 EACH
40 ALL
10 AA
20 EACH

Key
ALL=split between everyone
AA=split between Amy and Brian
AB= split between Carla and David
EACH = add amount to each person

Total amount owed each Name: Amy, Brian, Carla, David

Sorry couldn't format that terribly well. Would welcome your input.

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
 A B 1 10 ALL 2 20 ALL 3 30 AA 4 40 AB 5 10 ALL 6 20 AB 7 30 EACH 8 40 ALL 9 10 AA 10 20 EACH

<TBODY>
</TBODY>

You could use this formula:
 A B C 21 Amy =(SUMIF(B1:B10,"ALL",A1:A10)/4)+(SUMIF(B1:B10,"AA",A1:A10)/2)+(SUMIF(B1:B10,"EACH",A1:A10)) 90 22 Brian =(SUMIF(B1:B10,"ALL",A1:A10)/4)+(SUMIF(B1:B10,"AA",A1:A10)/2)+(SUMIF(B1:B10,"EACH",A1:A10)) 90 23 Carla (SUMIF(B1:B10,"ALL",A1:A10)/4)+(SUMIF(B3:B12,"AB",A3:A12)/2)+SUMIF(B4:B13,"EACH",A4:A13) 100 24 David (SUMIF(B1:B10,"ALL",A1:A10)/4)+(SUMIF(B3:B12,"AB",A3:A12)/2)+SUMIF(B4:B13,"EACH",A4:A13) 100

<TBODY>
</TBODY>

Thanks so much, this is exactly what I wanted!

Replies
9
Views
352
Replies
1
Views
109
Replies
2
Views
446
Replies
1
Views
135
Replies
1
Views
242

1,207,402
Messages
6,078,265
Members
446,324
Latest member
JKamlet

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back