Help .... sum function
 

Need help ... i have an excel document with a "customer number" in
column A ... and their "order totals" in column B

There are around 12000+ lines in the excel documnet.


Here is what i need .... I want a total that each customer had ordered
all year...


The "customer number" may be in the file 2 times or up to 15 times
(depends on how many orders they placed) ...

Just incase what i am saying makes no sence .... ill take the first
customer in the file

Customer # 1200101 has placed 5 orders .... 1 for $200, 1 for $60, 1
for $80 and 2 for $0... I want the database to end up with 1 line for
customer 1200101 with a total of $340.00 ....

Attached is my file


+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3905 |
+-------------------------------------------------------------------+

--
tallboy755
------------------------------------------------------------------------
tallboy755's Profile: http://www.excelforum.com/member.php...o&userid=28051
View this thread: http://www.excelforum.com/showthread...hreadid=475598

=SUMIF(A:A,"customer",B:B")

--
HTH

Bob Phillips

"tallboy755" wrote
in message ...

Need help ... i have an excel document with a "customer number" in
column A ... and their "order totals" in column B

There are around 12000+ lines in the excel documnet.


Here is what i need .... I want a total that each customer had ordered
all year...


The "customer number" may be in the file 2 times or up to 15 times
(depends on how many orders they placed) ...

Just incase what i am saying makes no sence .... ill take the first
customer in the file

Customer # 1200101 has placed 5 orders .... 1 for $200, 1 for $60, 1
for $80 and 2 for $0... I want the database to end up with 1 line for
customer 1200101 with a total of $340.00 ....

Attached is my file


+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3905 |
+-------------------------------------------------------------------+

--
tallboy755
------------------------------------------------------------------------
tallboy755's Profile:
http://www.excelforum.com/member.php...o&userid=28051
View this thread: http://www.excelforum.com/showthread...hreadid=475598

Not working for me .... <--- me ID10T ...... Can you apply it to my
file and re-attach it?


--
tallboy755
------------------------------------------------------------------------
tallboy755's Profile: http://www.excelforum.com/member.php...o&userid=28051
View this thread: http://www.excelforum.com/showthread...hreadid=475598

Nevermind ...<--- loser, idiot, freakwad brainless me got it to work
.... tks for the help


--
tallboy755
------------------------------------------------------------------------
tallboy755's Profile: http://www.excelforum.com/member.php...o&userid=28051
View this thread: http://www.excelforum.com/showthread...hreadid=475598