W
weejeow
Hie all,
i got a problem with summing. I do not know if it will work in excel
below are the sample: ("customer" is in column A
and "payment" is in column B):
customer | Payment
-----------------------------------
george | 20.00
john | 15.00
micheal | 25.00
john | 10.00
john | 5.00
george | 25.00
micheal | 10.00
Say that if a customer made multiple payment in a day, we need t
calculate the total payment. In this example, george have already pai
45.00, john paid 30.00 and so on. How do i automate this calculation?
I am actually a database guy and have no problem solving this usin
SQL:
select distinct customer,sum(payment) from table_name group b
customer
I need the final result looks something like this:
customer | Payment
-----------------------------------
george | 45.00
john | 30.00
micheal | 35.00
Any idea
i got a problem with summing. I do not know if it will work in excel
below are the sample: ("customer" is in column A
and "payment" is in column B):
customer | Payment
-----------------------------------
george | 20.00
john | 15.00
micheal | 25.00
john | 10.00
john | 5.00
george | 25.00
micheal | 10.00
Say that if a customer made multiple payment in a day, we need t
calculate the total payment. In this example, george have already pai
45.00, john paid 30.00 and so on. How do i automate this calculation?
I am actually a database guy and have no problem solving this usin
SQL:
select distinct customer,sum(payment) from table_name group b
customer
I need the final result looks something like this:
customer | Payment
-----------------------------------
george | 45.00
john | 30.00
micheal | 35.00
Any idea