Hello,
The function below works perfectly in a spreadsheet; however I would like to enter it as VBA code. As you can see, there are two columns with multiple conditions and one column with a single condition. Thanks in advance. - Rick
=SUM(SUMIFS($ER$11:$ER$100000,$C$11:$C$100000,{"00 002","00942","00102","00302"},$J$11:$J$100000,{"A" },$K$11:$K$100000,{"S";"N";"M";"P";"X"}))
