Tags: a4a53be2, average, d4d53, e4e53be2, excel, formula, h4h53, i4i53be2, l4l53, microsoft, msdn, software

Average formula

On Microsoft » Microsoft Excel

1,301 words with 1 Comments; publish: Wed, 04 Jun 2008 12:02:00 GMT; (30663.48, « »)

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

All Comments

Leave a comment...

  • 1 Comments
    • Hi Andrew!

      Enter the formula by pressing and holding down Ctrl and Shift and then

      pressing Enter.

      --

      Regards

      Norman Harker MVP (Excel)

      Sydney, Australia

      njharker.excel.todaysummary.com.optusnet.com.au

      "Andrew C" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:13f8e01c44468$599a52b0$a501280a.excel.todaysummary.com.phx.gbl...

      > 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

      #1; Wed, 04 Jun 2008 12:04:00 GMT