MinIfs Function

Question

Hello, I'm having trouble formatting the minifs statement in VBA. I want the code to look for the minimum value in a data table with two criteria's applied. This what I have so far, I'm not sure if I'm formatting the code wrong or if its another way I need to code it in VBA.

I figured out the formula format for the command but I want to run it in VBA, the formula format is the following:

Any help would be greatly appreciated, thanks!

hansvogelaar · Answer

Velasquezvictor&nbsp;
Instead of Application.WorksheetFunction.Evaluate, use Application.WorksheetFunction.MinIfs or shorter, Application.MinIfs

velasquezvictor · Answer

HansVogelaar&nbsp;I've tried that as well and it also doesn't seem to work&nbsp;

hansvogelaar · Answer

Velasquezvictor&nbsp;
Is Data the name of the worksheet? If so, change Data to Worksheets("Data")

velasquezvictor · Answer

Ah haha never mind I figured it out, I was misspelling it the whole time. Thanks!

Forum Discussion

MinIfs Function

4 Replies

Resources