Average formula

  • Thread starter Thread starter Andrew C
  • Start date Start date
A

Andrew C

Hi

Need some help.

{=AVERAGE(IF($A$4:$A$53=BE2,$D$4:$D$53),IF
($E$4:$E$53=BE2,$H$4:$H$53),IF
($I$4:$I$53=BE2,$L$4:$L$53),IF
($M$4:$M$53=BE2,$P$4:$P$53),IF
($Q$4:$Q$53=BE2,$T$4:$T$53),IF($U$4:$U$53=BE2,$X$4:$X$53))}

Can someone tell me how to get the little brackets at
start ad end of the formula. I asked how to do this
formula in this newsgroup about 6 months ago and i cant
remember.

Thanks

Andrew
 
Hi Andrew!

Enter the formula by pressing and holding down Ctrl and Shift and then
pressing Enter.
 
Back
Top