Results 1 to 2 of 2

Thread: Auto sum data across multiple sheets based on 2 criteria

  1. #1
    Neophyte jakmc25's Avatar
    Join Date
    Apr 2018
    Posts
    3
    Articles
    0
    Excel Version
    2016

    Auto sum data across multiple sheets based on 2 criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    So i need help with an excel document I've been working on, I've been stuck on this for awhile now. I have 2 things i'm trying to automate but i'm not sure if its possible.

    Basically this is used to track income based on client name, type of payment method, ect..

    1. What i'm trying to do is on the "Year to Date" sheet i have a client list that i manually update with new clients as i get them.
    Q: Is there a way that when a clients name is typed into one of the monthly sheets it will automatically reference this list on the "year to date" sheet and if the name isn't found it will add the name to the list?

    2. On the monthly sheets i put how much each client has paid during that visit and also how much they have tipped (some clients come multiple times a month).
    Q: On the "Year to Date" sheet i would like to sum up the amount paid and tipped throughout the year based on the clients first and last name.

    Any help with this would be greatly!
    Income Tracking per Client.xlsx

  2. #2
    Acolyte Azumi's Avatar
    Join Date
    Jan 2014
    Location
    Indonesia
    Posts
    30
    Articles
    0
    Excel Version
    2010
    Hope this helps
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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