Results 1 to 2 of 2

Thread: excel formulas, add up certain cells

  1. #1

    excel formulas, add up certain cells



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

    hi

    i am trying to work out a formula, but im having some difficulty, below is what i am trying to do.

    i need to be able to calculate how much i have billed a client for each month

    Sheet 1 - sales ledger

    Date Client Amount
    14/2 client 1 100
    15/2 client 2 50
    15/2 client 3 300
    16/2 client 1 200
    17/2 Client 3 500
    1/3 client 3 100
    5/3 client 1 400
    10/3 client 2 500

    and so

    sheet 2 - Monthly totals for each client

    Client Jan, Feb, Mar, Apr etc
    Client 1 total for that month amount

    etc

    can anyone help?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,491
    Articles
    0
    Excel Version
    Excel 2016
    You can use a Pivot table for that. See attached.

    Drag the Client to Row Labels, drag the date to the Column Label area, and drag amount to summation area.

    then right click on one of the dates in the Pivot Table, select Group, then Months. Click Ok.
    Attached Files Attached Files


Posting Permissions

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