Hi
I am new to this forum so please forgive me if i have posted this wrong.
I have a spread sheet i have been working and have come up stuck on something.
I have a sheet (Daily Banking) it list's payments made by clients thorough out the day (one client per row, working down the sheet. I have various drop down lists one of which (Payment Form) list's how they paid (Cash, Cheque or Card) at the end of the day i need to have totals for each of the these payment forms. The problem being is i have no idea how to achieve this. I though about sorting the list then doing a simple =sum equation to work out totals for each form of payment, the problem here is that the amount of payments change each day.
I have attached a copy of the sheet.
Many Thanks
Bookmarks