Results 1 to 3 of 3

Thread: Changing Formula

  1. #1

    Changing Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi everyone,
    I have a formula like this
    Code:
    =$A$185+SUMPRODUCT($B$14:$B$160;AF14:AF160)+SUMIF(AF14:AF160;"<1")
    and I need to change "$A$185" part to lastrow in column A
    I will be really glad if you help me.

  2. #2
    Try

    =LOOKUP(99^99,$A:$A)+SUMPRODUCT($B$14:$B$160;AF14:AF160)+SUMIF(AF14:AF160;"<1")

  3. #3
    Thank you very much Bob it worked !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •