rafaelapugliese
Board Regular
- Joined
- Jan 23, 2007
- Messages
- 85
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!!!!!
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!!!!!