View Single Post
  #1   Report Post  
Becky
 
Posts: n/a
Default array formulas-sumproduct and average

Hello, I need hel. I am using this formula
=SUMPRODUCT(--(E2:E289=1),--(AVERAGE (H2:H289))) I don't know what's wrong
with it. I need to find the average for column H in relation to 1(under 2
yrs) in Column E. Hope this makes sense.

Thanks,
Becky