title: Apply Countifs function to last non empty row in Excel
body: <p>I have 4 columns in excel. Data for first three column is getting populated by using Macro. On 4th column, I have applied Excel function countifs. I have applied it till 100th row. So if data is more than 100 row, function does not get apply to remaining rows. I want that, this formula should apply automatically to all those rows which contain non empty data may be those are less than 100 or more than 100. Please help.</p>