I am averaging columns of data for subtotals, however some columns contain 0's, thus giving me the #Div/0!

Just looking for the syntax in VBA to check my table at the end of my macro to replace the #Div/0!s with either 0's or - marks.


Here is my averageifs code:

"=AVERAGEIFS(R" & startrow & "C" & inty & ":R" & intx - 1 & "C" & inty & " , " & "R" & startrow & "C" & inty & ":R" & intx - 1 & "C" & inty & " , " & Chr(34) & ">0" & Chr(34) & ")"



Thank you!!