davidad wrote:
Is anybody out there aware of an "AVERAGEIF" function ?.
I'm new to programming and have failed miserably trying to
write it. Any help would be great.
--------------------------
Peo gave you the "right" solution. Here's the more intuitive one:
[ ] = SumIf(A1:A5,"0")/CountIf(A1:A5,"0")
Obviously you'll need to substitute your own arguments into it, but it
should give you the idea.
Bill
|