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?
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")
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!
Appreciate it, been goin at for hours still didn't how to do it, you're a lifesaver man
I am glad that it helped!
The way you taught is simple and easy to understand! Many thanks 🥰.
That means a lot Abdullah, thank you! I am very glad you enjoyed the video.
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
I don't think that you can use ARRAYFORMULA with VLOOKUP. Functions like VLOOKUP and COUNTIF have to be used in individual cells.
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?
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")
awesome video.
Thanks very much, I am glad to help!
Superb!!!
Thank you! It's great to hear that you enjoyed it!
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!
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.
Thank you!
Absolutely, glad it helped!
Great job
Thank you!
thanks
Absolutely!