# Formula to sum prices due to other value

#### rafaelapugliese

##### Board Regular
Hi!

I need a formula that identifies some values and sum the prices beside it.

Example:

...............B..................C
14 - \$ 910.000,00.......339039
15 - \$ 2.690.000,00....339039
16 - \$ 1.000.000,00....339030
17 - \$ 600.000,00.......339014

TOTAL
339039 - Formula that sum all values where in "C" that is 339039 (B14+B15)
339030 - Formula that sum all values where in "C" that is 339030
339014 - Formula that sum all values where in "C" that is 339014

Thanks!!!!!

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### jim may

##### Well-known Member
Check out the =SUMIF(CRITERIA_Range, Criteria_you_Want,SUM_Range)

=SUMIF(\$B\$1:\$B\$4,D1,\$A\$1:\$A\$4)

Where D1 is your 339039 value

#### xld

##### Banned
Try

=SUMIF(C:C,339039,B:B)

Thanks!!!!!!

Replies
2
Views
445
Replies
3
Views
214
Replies
1
Views
367
Replies
5
Views
500
Replies
24
Views
968

1,195,648
Messages
6,010,911
Members
441,572
Latest member
keobongda8812

### 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