+ Reply to Thread
Results 1 to 9 of 9

Totals By Months From Another Sheet Matching Category

  1. #1
    Forum Contributor
    Join Date
    12-15-2019
    Location
    Not here
    MS-Off Ver
    2010
    Posts
    257

    Totals By Months From Another Sheet Matching Category

    Hi,

    Can someone see why my formulas on the Actual sheet aren't putting the totals for each category and month. I highlighted the cells on the Transactions and Actual sheets in yellow.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,276

    Re: Totals By Months From Another Sheet Matching Category

    Change the formula in C6 to

    =DATE(Start4,COLUMN(A1),1)

    and copy across to N6.

    BTW, the fomula in B7 down has a #REF!

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,408

    Re: Totals By Months From Another Sheet Matching Category

    Yep. Change Actuals C6 to:

    =DATE(Start4,COLUMNS($A:A),1)

    and drag across.
    Glenn



  4. #4
    Forum Contributor
    Join Date
    12-15-2019
    Location
    Not here
    MS-Off Ver
    2010
    Posts
    257

    Re: Totals By Months From Another Sheet Matching Category

    Thanks for the reply. When I put that formula in C6 I get value errors.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,408

    Re: Totals By Months From Another Sheet Matching Category

    I don't....
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    12-15-2019
    Location
    Not here
    MS-Off Ver
    2010
    Posts
    257

    Re: Totals By Months From Another Sheet Matching Category

    Thanks Glenn it does work for the formulas but now I don't have the columns showing the Month titles like January, February, etc.

    Is there a way around this?

  7. #7
    Forum Contributor
    Join Date
    12-15-2019
    Location
    Not here
    MS-Off Ver
    2010
    Posts
    257

    Re: Totals By Months From Another Sheet Matching Category

    Sorry I didn't see the attachment. Thank you very much Glenn for the help.

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,408

    Re: Totals By Months From Another Sheet Matching Category

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

  9. #9
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    775

    Re: Totals By Months From Another Sheet Matching Category

    Actual

    C7=SUMPRODUCT(($A7=Transactions!$C$6:$C$17)*(Transactions!$F$6:$O$17)*(MONTH(Transactions!$A$6:$A$17)=MONTH(C$6))*(Transactions!$A$6:$A$17<>""))

    copy across and down

    Monthly Analysis

    C3=IF($A3<>"",SUMPRODUCT((Actual!$A$7:$A$36='Monthly Analysis'!$A3)*(MONTH(Actual!$C$6:$N$6)=MONTH($F$1&0))*(Actual!$C$7:$N$36)),"")

    Copy down
    Last edited by CARACALLA; 12-15-2019 at 09:09 AM.

+ 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. Replies: 4
    Last Post: 02-10-2019, 04:36 PM
  2. [SOLVED] VBA to group totals of each category within each date range
    By Jim885 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-30-2015, 12:59 PM
  3. Category Totals Using Lists
    By Liberty42 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-17-2013, 09:34 PM
  4. Pivot Table -- Category Grand Totals
    By Tyler.Primecp in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-14-2012, 01:33 PM
  5. [SOLVED] SUM TOTALS IF CATEGORY equals to defined values
    By lemuel in forum Excel General
    Replies: 5
    Last Post: 04-24-2012, 11:52 AM
  6. Adding category totals
    By Cryptographic_ICE@yahoo.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2006, 06:50 PM
  7. [SOLVED] Comparing/matching totals in a column to totals in a row
    By Nicole L. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2005, 07:06 PM

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