+ Reply to Thread
Results 1 to 4 of 4

Summarising annual data on separate sheet

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    Devon
    MS-Off Ver
    Excel for Mac 16.5
    Posts
    42

    Talking Summarising annual data on separate sheet

    Hi

    In the attached sheet, we add the credit card transaction costs on a monthly basis in to sheet Card Charges (2) - eg D4 = 91.35.

    Our Financial Year runs October through to the following September, so hat I am trying to do on Annual Analysis is to consolidate all of the charges for a particular cell, for that year - e.g. Annual Analysis C4 would be the sum of Card Charges (2) D4:O4.

    Whilst I could do this with Sum, I think that there must be an easier way using SumProduct so that I can set up the whole sheet more easily, rather than having to do individual Sums on each cell.

    Can anyone help me with the please?

    thanks
    Attached Files Attached Files
    Last edited by devonalex; 02-03-2015 at 01:39 PM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,578

    Re: Sumproduct

    What you entered in Annual analysis sheet is correct
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,596

    Re: Sumproduct

    Hi. Is this what you had wanted?
    Attached Files Attached Files
    Glenn



  4. #4
    Registered User
    Join Date
    06-17-2014
    Location
    Devon
    MS-Off Ver
    Excel for Mac 16.5
    Posts
    42

    Re: Summarising annual data on separate sheet

    Thanks Glen - not sure I would have ever got to that!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count SUMPRODUCT Members / Average of SUMPRODUCT
    By Shingaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 03:59 PM
  2. Replies: 1
    Last Post: 05-19-2012, 02:54 AM
  3. Replies: 5
    Last Post: 04-20-2012, 08:54 AM
  4. Replies: 6
    Last Post: 03-09-2011, 08:01 AM
  5. Using a SumProduct Count to find a SumProduct Total?
    By XL021710 in forum Excel General
    Replies: 3
    Last Post: 02-18-2010, 08:31 AM

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