Question

[refai85]

Dear All,
can you please answer me this question belwo:
check the table below:

CUSTOMER ID ITEM X Amount Item Y Amount Total Sales
100001221 150$ 100$ 350$
122334445 250$ 200$ 450$
100001221 350$ 200$ 550$
100001221 100$ 250$ 350$
122334445 230$ 230$ 460$
122334445 100$ 100$ 200$

My question is, I want to make a report by customer so that it automatically sums up all cells for the all customers in one sheet.

can you please help ??? Urgent

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.