Help .... sum function

[tallboy755]

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

[Bob Phillips]

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

--
HTH

Bob Phillips

"tallboy755" <tallboy755.1wt4yi_1129151125.7394@excelforum-nospam.com> wrote
in message news:tallboy755.1wt4yi_1129151125.7394@excelforum-nospam.com...
>
> 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
>

[tallboy755]

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

[tallboy755]

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