using the output (last row number) of a function for another function, say, COUNTIF

[Zakky]

Hi, I have used a formula (thanks to Mr. Excel.com team) to find the last populated row. I want to link/feed this number to another function, say, COUNTIF. how can i reference the last cell number into the Countif function?

my formula in cell A2 is =MAX((G:G<>"")*(ROW(G:G))) which returns 234814. Now i want to do in cell E1 =COUNTIF(E2:E234814,"A"). I want to make COUNTIF dynamic, so as length of data changes the Countif picks up the last row and updates automatically without me having to adjust it to last row manually. I changed E234418 to A2 but it didn't work. Thank you.

 

[AlphaFrog]

Try this...
=COUNTIF(INDIRECT("E2:E" & A2),"A")

Alternatively, reference the entire column in the formula. It doesn't slow Excel down. Excel formulas inherently know what the last used row on the sheet is.
=COUNTIF(E:E,"A")

 

[Zakky]

AlphaFrog, marvelous job! Both functions work. Always good to have a choice . have a nice day/evening, and, thank you!.