Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Help Needed

  • 23-01-2024 12:45PM
    #1
    Ivor_Guddon
    Registered Users, Registered Users 2 Posts: 306 ✭✭


    Apologies if this is in the wrong section

    i'm looking at creating a service log in excel

    basically all the services be on the left , every week we invoice said customer for these services , could be 7-10 services

    but i want to keep a log in excel so at the end of the month i can see how many times a particular service was used and also its associated costs

    anybody any idea how to do this ?

    much appreciated



Comments

  • #2
    AndrewJRenko
    Registered Users, Registered Users 2 Posts: 33,451 ✭✭✭✭AndrewJRenko


    Create a table in Excel with one row for each time the service is used, something like;

    Customer number, date/time, type of service, cost, and possibly other stuff like staff member, duration.

    You can just sort by customer number, and get a total of the cost each month, or you could use pivot tables if you want to do something a bit more fancy.



Advertisement