Results 1 to 4 of 4

Summarising annual data on separate sheet

Threaded View

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

    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.

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