View Single Post
  #3   Report Post  
Max
 
Posts: n/a
Default

And if an error trap is needed to return blanks: ""
instead of #DIV/0! , then try:

=IF(ISERROR(AVERAGE(IF(E2:E289=1,H2:H289))),"",AVE RAGE(IF(E2:E289=1,H2:H289)
))

(Array entered as before)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----