Results 1 to 8 of 8

Quick Copy SUMIFS

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2018
    Location
    Minnesota
    MS-Off Ver
    Excel 2018
    Posts
    15

    Quick Copy SUMIFS

    Hello! I am an excel novice. So please excuse any absurdity.
    I have a SUMIF formula that I'd like to repeat.

    Column A states a number:
    "11.00
    11.51
    11.98
    11.99
    xx.00
    xx.51
    xx.98
    xx.99
    xx.00
    xx.51
    xx.98
    xx.99"

    This pattern continues through 300:
    "300.00
    300.51
    300.98
    300.99"

    I have a SUMIF formula:
    SUMIFS(B:B,A:A,">=11.00",A:A,"<11.50")
    SUMIFS(B:B,A:A,">=11.51",A:A,"<11.97")
    SUMIFS(B:B,A:A,"11.98")
    SUMIFS(B:B,A:A,"11.99")

    I need to copy the formula down to 300. Currently if I drag it down, the numbers stay the same. I need the numbers to automatically update in the formula as it is copied as opposed to manually typing in the updated number:
    "SUMIFS(B:B,A:A,">=11.00",A:A,"<11.50")
    SUMIFS(B:B,A:A,">=11.51",A:A,"<11.97")
    SUMIFS(B:B,A:A,"11.98")
    SUMIFS(B:B,A:A,"11.99")
    SUMIFS(B:B,A:A,">=12.00",A:A,"<12.50")
    SUMIFS(B:B,A:A,">=12.51",A:A,"<12.97")
    SUMIFS(B:B,A:A,"12.98")
    SUMIFS(B:B,A:A,"12.99")
    SUMIFS(B:B,A:A,">=13.00",A:A,"<13.50")
    SUMIFS(B:B,A:A,">=13.51",A:A,"<13.97")
    SUMIFS(B:B,A:A,"13.98")
    SUMIFS(B:B,A:A,"13.99") so on and so forth through 300....


    I've attached a spreadsheet that has all the factors in it. Thank you for any help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Is ther a quick way to copy this down?
    By dmillsmartclean in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2017, 01:20 PM
  2. Is there a quick way to copy this down
    By dmillsmartclean in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2017, 12:19 PM
  3. How to consolidate different sheets into one
    By keychain in forum Excel General
    Replies: 3
    Last Post: 01-29-2016, 01:16 AM
  4. Quick Vba question to copy from the last row to the second row of the data
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2014, 12:51 PM
  5. I'm looking for a quick way to copy data from one worksheet to another
    By robjbc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2012, 11:58 AM
  6. [SOLVED] Quick Copy
    By JokerDan22 in forum Excel General
    Replies: 1
    Last Post: 10-12-2012, 10:46 AM
  7. Quick Copy
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2005, 12:21 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