Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |