+ Reply to Thread
Results 1 to 4 of 4

How to Sumif between Rows that have criteria/specific text

  1. #1
    Registered User
    Join Date
    10-01-2015
    Location
    london
    MS-Off Ver
    2010
    Posts
    9

    Question How to Sumif between Rows that have criteria/specific text

    Hi
    Ive been racking my brain trying to solve an issue with an ever changing export.
    I need a Sumif formula to search between two rows depending on the text in them
    Excell question.PNG

    Im looking to Sumif "payment method 1", but the number of rows with "payment method 1" can change from export to export.
    And the starting row of "Declared payments" can change.
    So ideally i want to Sum If between a range criteria set by the text: "Declared payments" & "Total Declared payments".

    To complicate things more i cant just Sumif the whole sheet as i need to ignore some "payment method 1", where its not applicable.

    I thought a Sumif and Vlookup, but i dont know how to make them work together?
    Attached Files Attached Files
    Last edited by zendetta2608; 12-09-2020 at 10:52 AM.

  2. #2
    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,647

    Re: How to Sumif between Rows that have criteria/specific text

    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.

  3. #3
    Registered User
    Join Date
    10-01-2015
    Location
    london
    MS-Off Ver
    2010
    Posts
    9

    Re: How to Sumif between Rows that have criteria/specific text

    Thanks for that, ive edited the post with my example attached.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: How to Sumif between Rows that have criteria/specific text

    This proposal employs a helper column (A) which may be moved and/or hidden for aesthetic purposes.
    The helper column is populated using: =IF(B5="Declared paymemnts","Use",IF(B5="Total Declared Payments","",A4))
    The Sumifs function in cell M5 is: =SUMIFS(J6:J20,A6:A20,"Use",B6:B20,"Payment Method 1")
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. SUMIF - Sum up all the total number when no specific criteria selected
    By Tracy Tan in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-13-2017, 10:45 AM
  2. [SOLVED] Copy rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  3. SumIF with multiple columns with non-specific text criteria
    By Funky_Finance in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-22-2014, 02:19 PM
  4. Replies: 4
    Last Post: 09-18-2012, 10:54 AM
  5. Delete rows which do not meet specific criteria (text values)
    By dim06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2012, 09:54 AM
  6. Replies: 4
    Last Post: 05-04-2010, 02:25 PM
  7. SUMIF with multiple criteria, one criteria a specific string
    By Weasel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2008, 05:32 PM

Tags for this Thread

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