Averageifs with an integer variable as criteria

[nmk34]

in excel worksheet i use for example:
=(AVERAGEIFS(B4:B262078,C4:C262078,">"&S2,C4:C262078,"<"&N2,B4:B262078,">"&1130,B4:B262078,"<"&1149))
then in vba i use:
Public SelectedProductMin SelectedProductMax as integers 'IN ANOTHER MODULE

of5minago = WorksheetFunction.AverageIfs(Worksheets("sheet1").Range("B4:B262078"), _
Worksheets("sheet1").Range("C4:C262078"), ">" & Worksheets("sheet1").Range("S2"), _
Worksheets("sheet1").Range("C4:C262078"), "<" & Worksheets("sheet1").Range("N2"), _
Worksheets("sheet1").Range("B4:B262078"), ">" & SelectedProductMin, Worksheets("sheet1").Range("B4:B262078"), "<" & SelectedProductMax)

the above code works in excel vba when i use numbers instead of SelectedProductMin and SelectedProductMax . what i want to do replace 1130 and 1149 with integer variables like above. i declareed the variables public in another module. these two integer variables are based on selected index value from a listview control. i keep getting an error. if use constants it works but not variables. Please help, i could not find any thread anywhere on this

 

[RoryA]

Aside from the fact you need:

Public SelectedProductMin As Integer, SelectedProductMax as integer

your code is fine - assuming you assign those two variables a value (otherwise they default to 0)

 

[nmk34]

of5minago = WorksheetFunction.AverageIfs(Worksheets("sheet1").Range("B4:B262078"), _
Worksheets("sheet1").Range("C4:C262078"), ">" & Worksheets("sheet1").Range("S2"), _
Worksheets("sheet1").Range("C4:C262078"), "<" & Worksheets("sheet1").Range("N2"), _
Worksheets("sheet1").Range("B4:B262078"), ">" & SelectedProductMin, Worksheets("sheet1").Range("B4:B262078"), "<" & SelectedProductMax)
code halts when i run it at this code above. if i move my mouse over SelectedProductMin i see a value of 216 and move the mouse over SelectedProductMax and i see a value of 228.
the error code:
image attached

 

[RoryA]

You'd get that error if nothing matches your criteria (just as AVERAGEIFS would return an error as a formula).