No need to write a function, you can use a combination of average and if
as an example
=AVERAGE(IF(Range=criteria,Range))
entered with ctrl + shift & enter
Regards,
Peo Sjoblom
"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.
|