Results 1 to 3 of 3

Adding up totals from drop down list slections

Threaded View

  1. #1
    Registered User
    Join Date
    02-28-2011
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel Mac 2011
    Posts
    1

    Adding up totals from drop down list slections

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1