Dynamic cell reference in countif function

I have a spreadhseet holding a list of grade 1 learners. Obviously the number of learners can vary over time. I am using an array formula to find the reference of the last cell containig a name. This reference I want to use in a countif function. Let’s say the array formula returns B40, then I want to use the B40 in the COUNTIF function as follows: COUNTIF(B4:B40,N3). How can I insert the cell reference obtained by the array formula into the COUNTIF function?

Leave a Reply

Your email address will not be published. Required fields are marked *