+ Reply to Thread
Results 1 to 8 of 8

Indirect formulas

  1. #1
    Registered User
    Join Date
    10-17-2012
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    9

    Talking Indirect formulas

    Hi, How do I insert indirect into my formula, I tried and it came back with error
    =SUM(IF(MONTH('Quote Register'!$K$13:$K$257)=MONTH(Q$4),IF(YEAR('Quote Register'!$K$13:$K$257)=YEAR(Q$4),IF('Quote Register'!$L$13:$L$257=$B5,IF('Quote Register'!$E$13:$E$257=$D$2,'Quote Register'!$O$13:$O$257,IF($D$2="(ALL)",'Quote Register'!$O$13:$O$257,0)),0),0),0))

    Everytime I add a new line into my spreadsheet it goes from $K$13 to $K14$, I wiah to have my email stay always at $K$13

    Thank you

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Indirect formulas

    Hi Monza2,

    For me this appears to be an array formula else how will you evaluate " IF(MONTH('Quote Register'!$K$13:$K$257)=MONTH(Q$4)" .. also which part in this formula you want to reference using Indirect ?? thanks

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    10-17-2012
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Indirect formulas

    Yes its an array formula, the refererence for indirect is $K$13
    Thank you

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Indirect formulas

    I guess, you need to upload the sample workbook.. please attach. thanks.



    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,680

    Re: Indirect formulas

    If you want to use the indirect for K13 alone then replace the K13 reference with the below one

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you want to use the indirect for K13:K257 then replace the K13:K257 reference with the below one

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Hope that helps!


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  6. #6
    Registered User
    Join Date
    10-17-2012
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Indirect formulas

    I have uploaded my spreadsheet.

    The sheet is called "Forcast by %" and references back to "Quote Register"

    Thank you very much for your assistance, greatly appreacited
    Attached Files Attached Files

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,680

    Re: Indirect formulas

    Try the below ARRAY Formula in D5 cell

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Try the below one for NON ARRAY Formula in D5 cell

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Refer the attached excel for details.

    Hope that helps!
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    10-17-2012
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Indirect formulas

    That worked perfectly Sixthsense, apologies for the delay in response, I have been away all this week.

    Once again I greatly appreciated your assitance, many thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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