ARRAYFORMULA function: Apply a formula to an entire column in Google Sheets

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น • 20

  • @satgursarao6085
    @satgursarao6085 3 ปีที่แล้ว +2

    Appreciate it, been goin at for hours still didn't how to do it, you're a lifesaver man

  • @abdullahfaizal7739
    @abdullahfaizal7739 3 ปีที่แล้ว +2

    The way you taught is simple and easy to understand! Many thanks 🥰.

    • @spreadsheetclass
      @spreadsheetclass  3 ปีที่แล้ว +1

      That means a lot Abdullah, thank you! I am very glad you enjoyed the video.

  • @codyb4240
    @codyb4240 2 ปีที่แล้ว +1

    Can you tell me how it would work with a v lookup? I’m trying to use this logic and can’t get my v lookup to carry all the way down

    • @spreadsheetclass
      @spreadsheetclass  ปีที่แล้ว

      I don't think that you can use ARRAYFORMULA with VLOOKUP. Functions like VLOOKUP and COUNTIF have to be used in individual cells.

  • @GArvinthKrishna
    @GArvinthKrishna 2 ปีที่แล้ว +1

    if I want to use countif in arrayformula for my all cells in a row:
    eg:
    =countif(c4:c16,"YES") -> this Formula i will put in c19 cell and i wanna continue like that d19,e19..... relatively....
    can you please help?

    • @spreadsheetclass
      @spreadsheetclass  4 หลายเดือนก่อน

      Are you trying to get a running total where when you copy the formula down the column it still counts from the top but keeps counting more rows each time you copy the formula down? If so, you can lock the reference to the beginning row like this, with a dollar sign: =countif(c$4:c16,"YES")

  • @skeeter1668
    @skeeter1668 2 ปีที่แล้ว +1

    awesome video.

  • @narendranandaniya9566
    @narendranandaniya9566 2 ปีที่แล้ว +1

    Superb!!!

    • @spreadsheetclass
      @spreadsheetclass  ปีที่แล้ว

      Thank you! It's great to hear that you enjoyed it!

  • @vipdesign9
    @vipdesign9 ปีที่แล้ว

    Hello, can you show me how you can use the function "arrayformula" where you make a calculation using data from a previous row. It works when you use a reference to a next row but not to a previous row. It would be helpful for me. Thanks in advance. I get always the message #REF!

    • @spreadsheetclass
      @spreadsheetclass  ปีที่แล้ว

      Something like this? =ARRAYFORMULA(G1:G4*H2:H5)
      It may be that you need to specify ending rows where each column has the same number of cells.

  • @migmig5613
    @migmig5613 3 ปีที่แล้ว +2

    Thank you!

  • @dalmarielawrence6237
    @dalmarielawrence6237 3 ปีที่แล้ว +2

    Great job

  • @lilisupriyanto2345
    @lilisupriyanto2345 3 ปีที่แล้ว +2

    thanks