Removing #Div/0! from AVERAGEIFS function

**Oqualli** · 06-15-2011, 11:10 AM

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!!

**daddylonglegs** · 06-15-2011, 11:15 AM

Try using IFERROR, i.e.

Please Login or Register  to view this content.

**Ron Coderre** · 06-15-2011, 11:16 AM

Try this...

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

Does that help?