Formula to sum prices due to other value

[rafaelapugliese]

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

 

[jim may]

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]

Try

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

 

[rafaelapugliese]

Thanks!!!!!!