I never used DAVERAGE but can't this be accomplished with AVERAGEIF function?
=AVERAGEIF(A2:A10,">0")
A B 1Table Average 2 25 17.71 3 12 4 35 5 1 6 #NAME? 7 12 8 #DIV/0! 9 12 10 27
I never used DAVERAGE but can't this be accomplished with AVERAGEIF function?
=AVERAGEIF(A2:A10,">0")
A B 1Table Average 2 25 17.71 3 12 4 35 5 1 6 #NAME? 7 12 8 #DIV/0! 9 12 10 27
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks