Aaron,
It's:
=SUMIF(C6:O6,"Actual",C19:O19)/MAX(1,COUNTIF(C6:O6,"Actual"))
where C6:O6 houses fields like "Actual" and C19:O19 corresponding percentages that you want to average depending on the field that figures as condition/criterion.
Aladin
This message was edited by Aladin Akyurek on 2002-05-10 04:34