PDA

View Full Version : Solved: Need help easy formula



neditheg
08-01-2008, 04:36 AM
Hello guys!! I need a formula to sum some numbers

I have this issue :

Operators operators number of sales

AAA 1
BBB 2
AAA 2
CCC 4
AAA 2
CCC 3
BBB 3
AAA 3

and I need a formula to sum the sales for each operator

like this

AAA 8
BBB 5
CCC 7

It may be easy but pls help me!! (my english sucks! so i'll upload a file)

Tanks!!

f2e4
08-01-2008, 04:50 AM
Hello guys!! I need a formula to sum some numbers

I have this issue :

Operators operators number of sales

AAA 1
BBB 2
AAA 2
CCC 4
AAA 2
CCC 3
BBB 3
AAA 3

and I need a formula to sum the sales for each operator

like this

AAA 8
BBB 5
CCC 7

It may be easy but pls help me!! (my english sucks! so i'll upload a file)

Tanks!!

Just use the sumproduct function

See attached file

Bob Phillips
08-01-2008, 04:58 AM
SUMIF should be sufficient here

=SUMIF($A:$A,$E2,B:B)

f2e4
08-01-2008, 05:00 AM
even a simple pivot table would do the job

neditheg
08-01-2008, 05:01 AM
thanks!

how do i make this threand SOLVED :?

mdmackillop
08-01-2008, 05:23 AM
Thread tools dropdown