none
Converting Formula to Indirect RRS feed

  • Question

  • I am just learning how to use the =INDIRECT function. 

    How would I convert the following formula to =INDIRECT? I need it to stop adjusting the 2nd criteria range when I delete columns.

    =COUNTIFS(FP!$A:$A, ShortCount!$A2, FP!$H:$H, ">=" & EOMONTH($A$1, -12))


    • Edited by Myysterio Wednesday, May 18, 2016 9:00 AM
    Wednesday, May 18, 2016 8:59 AM

Answers

  • You can change

    FP!$H:$H

    to

    INDIRECT("FP!$H:$H")


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Myysterio Wednesday, May 18, 2016 1:11 PM
    Wednesday, May 18, 2016 1:01 PM

All replies