+ Reply to Thread
Results 1 to 4 of 4

SUMIF 5 times , how to fix cell

  1. 11-06-2015, 04:42 AM #1
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    SUMIF 5 times , how to fix cell

    I have this formula

    Please Login or Register  to view this content.
    What should be the formula to drag right so that it picks up

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 11-06-2015, 04:43 AM #2
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    Re: SUMIF 5 times , how to fix cell

    And then Further drag right 3 cells to auto pick P Q and R with the M and A in the formula fixed
    Reply With QuoteRegister To Reply
  3. 11-06-2015, 04:44 AM #3
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    Re: SUMIF 5 times , how to fix cell

    It has to do that fix cell or you call it absolute , not sure what it is , adding of dollars signs by F4
    Reply With QuoteRegister To Reply
  4. 11-06-2015, 04:47 AM #4
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    Re: SUMIF 5 times , how to fix cell

    I got it I think

    Please Login or Register  to view this content.
    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 wildcard , doing manually 300 times will take long
    By makinmomb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-08-2014, 02:01 AM
  2. Using SUMIF and INDIRECT multiple times in the same equation
    By bbo^1053 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2013, 02:55 AM
  3. Using SUMIF and INDIRECT multiple times in the same equation
    By bbo^1053 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-09-2013, 05:17 PM
  4. If a search term can be found 1 time, 2 times 3 times 4 times 5 times
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 09:57 PM
  5. SumProduct / Sumif, within 2 times
    By Henry c in forum Excel General
    Replies: 10
    Last Post: 01-20-2010, 09:25 AM
  6. using sumif to add times
    By 2newguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2007, 01:21 PM
  7. trying to add times with Sumif-
    By 2newguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2007, 12:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1