+ Reply to Thread
Results 1 to 2 of 2

SUMIF function including EOMonth or Date Range

  1. 06-05-2020, 07:19 PM #1
    harmanm
    harmanm is offline
    Registered User
    Join Date
    06-05-2020
    Location
    Seattle
    MS-Off Ver
    Google Sheets
    Posts
    2

    SUMIF function including EOMonth or Date Range

    Hi All,

    Basically I have a document where I have loans closing during a certain month with the loan amount. I needed a formula which counts the loan volume based on two variables (Source & HT/EDHL) being true during a single month. I've got the part of the formula that calculates the volume with the two variables being present but can't figure out how to make it so the sum is only during that certain month (ie. Jan, Feb) right now the result is for the entire year.

    Current Formula:
    =SUMIFS('Pending Business'!K:K,'Pending Business'!O:O,"EDHL",'Pending Business'!E:E,"Amandeep")
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 06-06-2020, 01:36 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,777

    Re: SUMIF function including EOMonth or Date Range

    Is this for Google Sheets?

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIF, with both the sum range and the criteria range including N/A Values
    By ad2097 in forum Excel General
    Replies: 4
    Last Post: 09-04-2019, 05:29 AM
  2. Using EOMONTH, without including a Leap Year, or other suggestions...
    By rcm242 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-05-2017, 11:16 PM
  3. [SOLVED] Advanced SUMIF - date range including missing dates
    By chococ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2015, 02:12 PM
  4. [SOLVED] including a date range in SUMIF
    By Emma Blower in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2014, 05:24 PM
  5. SUMIF function including 'AND'
    By jdm86 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2013, 02:25 AM
  6. [SOLVED] SUMIF within date range as a function of today()'s date
    By irvine79 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-06-2006, 01:00 PM
  7. [SOLVED] How do I do a sumif function not including hidden rows?
    By Verlaesslichkeit in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-03-2006, 08:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1