Sales report by customer and sales team

[Chong Meng]

CELL REF	A	B	C	D	E	F	G	H
1 <tbody> </tbody>	RAW DATA RECORDS (INCREASE DAILY), NEW CUSTOMER (MAY ADD ON FROM TIME TO TIME)
2 <tbody> </tbody>	DATE <tbody> </tbody>	CUSTOMER <tbody> </tbody>	AMOUNT <tbody> </tbody>	SALES TEAM
3 <tbody> </tbody>	09-Jan-14 <tbody> </tbody>	X	100	A
4 <tbody> </tbody>	24-Jan-14 <tbody> </tbody>	Y	200	A
5	17-Feb-14 <tbody> </tbody>	Z	300	B
6	24-Feb-14 <tbody> </tbody>	X	400	A
7	05-Mar-14 <tbody> </tbody>	Y	500	A
8	17-Mar-14 <tbody> </tbody>	Z	600	B
9	03-Apr-14 <tbody> </tbody>	X	700	A
10	08-May-14 <tbody> </tbody>	Y	800	A
11	30-May-14 <tbody> </tbody>	Z	900	B
12
13	SALES REPORT BY CUSTOMER (JAN - DEC 2014) <tbody> </tbody>
14	RANKING	CUSTOMER	JAN	FEB	MAR	APR	MAY	TOTAL
15	1	Z		300	600		900	1800
16	2	Y	200		500		800	1500
17	3	X	100	400		700		1200
18	TOTAL <tbody> </tbody>		300	700	1100	700	1700	4500
19	SALES REPORT BY SALES TEAM (JAN - DEC 2014) <tbody> </tbody>
20	RANKING	SALES TEAM	JAN	FEB	MAR	APR	MAY	TOTAL
21	1	A	300	400	500	700	800	2700
22	2	B		300	600		900	1800

<tbody>
</tbody>

CRITERIA 1

BOTH REPORTS ABLE TO SORT CUSTOMER/SALE TEAM AUTOMATICALLY ACCORDING TO

RANKING BASE ON TOTAL SALES AMOUNT OF EACH CUSTOMER/SALES TEAM.

CRITERIA 2

A FORMULA TO REFER RAW DATA RECORDS, SUM AMOUNT BASE ON MONTHLY COLUMN AND BY CUSTOMER.

THUS ONLY 2 TYPES FOR FORMULA NEED YOUR ASSISTANCE.

CELL B15 - B17, B21 - 22

CELL C15 - G 17, C21 - G22

I HOPE MY QUESTIONS ARE CLEAR, SHOULD YOU HAVE ANY DOUBTS, PLEASE FEEL FREE TO ADVISE ME. MAY I KNOW HOW TO EXPORT MY EXCEL DATA INTO THIS TABLE CORRECTLY, I COULDN'T MERGE THE CELL AND END UP MY "A" COLUMN TAKE UP EXTRA LENGTH.

THANK YOU VERY MUCH. CHONG MENG

<tbody>
</tbody>

OMG! WHAT HAPPEN TO THE COLUMN.............