+ Reply to Thread
Results 1 to 4 of 4

Sumifs for Dates. Sum total for each month

  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Sumifs for Dates. Sum total for each month

    I'm looking for a formula to give me the totals in YELLOW. I don't want to include any helper columns. thx!
    Attached Files Attached Files
    Last edited by Xx7; 02-20-2014 at 10:24 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,476

    Re: Sumifs for Dates. Sum total for each month

    You can use this formula in G3:

    =SUMPRODUCT(--(TEXT(A$6:A$33,"mmm yyyy")&" RENT"=F3),B$6:B$33)

    then copy down.

    Hope this helps.

    Pete

  3. #3
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,309

    Re: Sumifs for Dates. Sum total for each month

    See attached
    Attached Files Attached Files
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Sumifs for Dates. Sum total for each month

    Beauty! thanks both

+ 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. [SOLVED] A formula to calc total number of days elapsed between two dates within any given month
    By paul.a.evans in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2014, 01:29 AM
  2. Lookup total per month (overlapping dates)
    By IKZOUHETNIETWETEN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2013, 06:00 AM
  3. [SOLVED] Total number of the dates of a month that have data, so far
    By agios59 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-12-2013, 09:44 AM
  4. evaluate range of dates for total same month occurences
    By rthrelk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-29-2012, 07:23 PM
  5. Replies: 4
    Last Post: 08-28-2012, 01: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