Indirect formulas

1. 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. 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>

3. Re: Indirect formulas

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

4. 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. Re: Indirect formulas

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

Formula:
`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:
`Please Login or Register  to view this content.`

Hope that helps!

6. Re: Indirect formulas

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

Thank you very much for your assistance, greatly appreacited

7. Re: Indirect formulas

Try the below ARRAY Formula in D5 cell

Formula:
`Please Login or Register  to view this content.`

Try the below one for NON ARRAY Formula in D5 cell

Formula:
`Please Login or Register  to view this content.`

Refer the attached excel for details.

Hope that helps!

8. 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

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

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