Offset Sumifs VBA is killing me

[chenyu768]

HELP EXCEL GURUS!!!!
So i got a range named Index_Rev which covers like 36 columns.
I'm trying to basically do this but in VBA

=SUMIFS(OFFSET(Index_Rev,0,Column_num,,1),Index_CustID,E19)

Function CL_MTM(Cust_Id, k_Type, Column_num)

If k_Type = "Index" Then
CL_MTM = WorksheetFunction.SumIfs(Range("Index_Rev").Offset(0, Column_num), Range("Index_CustID"), Cust_Id)

Else
......
End if
End Function


HELPPPPPPPPPPPPPPPP!!!!!!!!!!!!!!!!!!!!!