MinIfs Function

[Velasquezvictor]

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!

[#2]

@Velasquezvictor 

Instead of Application.WorksheetFunction.Evaluate, use Application.WorksheetFunction.MinIfs or shorter, Application.MinIfs

[#3]

@Hans Vogelaar 

I've tried that as well and it also doesn't seem to work

[#4]

@Velasquezvictor 

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

[#5]

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