I am trying to have subtotals calculate a range of values in a column that includes 0s. I would like to exclude the 0s, so as to calculate the average of the values that aren't a 0 only.
"=AVERAGE(IF(R" & startrow & "C" & inty & ":R" & intx - 1 & "C" & inty & " , " & " >0 " & "))"
Any help would be greatly appreciated!
Jo Oqualli and welcome to the forum,
Find the attached that you can use as an example to get your answer.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you so much @MarvinP
It worked well, now just trying to find a way to hide the #Div/0!s
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks