+ Reply to Thread
Results 1 to 4 of 4

SUMIF OR SUMIFS functions with criteria as formula

  1. 04-28-2014, 10:19 AM #1
    akbarmajor
    akbarmajor is offline
    Registered User
    Join Date
    04-17-2014
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    11

    Post SUMIF OR SUMIFS functions with criteria as formula

    Hi All,
    Need help with SUMIF and SUMIFS formula, where in I want to set criteria in the formula as greater than or less than or equal to value derived from another formula. I am inserting the following formula but excel is not allowing me to enter the formula.

    =SUMIFS($C$22:$C$30,$E$22:$E$30,>=LEFT(L21,3),$E$22:$E$30,<=RIGHT(L21,3),$A$22:$A$30,G22)

    I am attaching an excel to explain the issue further.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-28-2014, 10:48 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: SUMIF OR SUMIFS functions with criteria as formula

    Hi,

    Your syntax was just incorrect:

    =SUMIFS($C$5:$C$10,$E$5:$E$10,">="&LEFT(H4,3),$E$5:$E$10,"<="&RIGHT(H4,3))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 04-28-2014, 10:50 AM #3
    bebo021999
    bebo021999 is online now
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: SUMIF OR SUMIFS functions with criteria as formula

    Try:
    =SUMIFS($C$5:$C$10,$E$5:$E$10,">="&LEFT(H4,3),$E$5:$E$10,"<="&RIGHT(H4,3))
    Quang PT
    Reply With QuoteRegister To Reply
  4. 05-08-2014, 09:43 AM #4
    akbarmajor
    akbarmajor is offline
    Registered User
    Join Date
    04-17-2014
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: SUMIF OR SUMIFS functions with criteria as formula

    Thanks alot guys it worked as per my requirement to perfection.
    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. Multiple items on criteria for SUMIF (but not with SUMIFS)
    By Pullo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2014, 01:17 PM
  2. [SOLVED] SUMIF or SUMIFS with Array Criteria
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2014, 11:25 AM
  3. How to SUM using some odd criteria? SUMIFS or SUMIF will not work...
    By joaolopes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 01:12 PM
  4. Complicated SumIfs/Sumif functions
    By WadeLair in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-25-2013, 01:19 PM
  5. [SOLVED] SumIf / SumIfs with multiple Contains Text criteria
    By theweirdone in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2012, 05:22 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1