EXCEL Function equivalent to Current Region

Dear friends,

I have a sheet with data. I would like to calculate nonzero minimum value of a column. For example, I am using the function

Please Login or Register  to view this content.

to calculate the minimum COST (in column D:D) of an item TOOLS (in column B:B).

The problem is that when I consider the whole column as data, any operation on the sheet recalculates and the whole procedure is slowed down. At present, I have 340 rows of data. But this will be varying. Is there a method to use a formula, not as an array formula to achieve this?

Is there any equivalent of CurrentRegion function, which I can use in EXCEL function? How can I modify the function to incorporate all the data?

I had read about function MINIFS, but using that function gives error in my excel version (Microsoft Office Professional Plus 2013).

Regards,
Pravin Kumar.