Average IF's
in [Functions]
|
From: Noodnutt on 27 May 2010 16:47 Hi Guy's Can anyone help me out with the 2K version of the following plz. =IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)) This works great in 2007, but as with most things work related, they don't have 2007 installed. TIA Mark.
From: Fred Smith on 27 May 2010 18:36 Average is Sum/Count, so use: =IF($C8=0,0,SUMIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)/COUNTIF(Data!$AC$2:$AC$10000,"MAR-10")) Regards, Fred "Noodnutt @ Work" <markl(a)camerons.com.au> wrote in message news:eEiD%232d$KHA.1700(a)TK2MSFTNGP02.phx.gbl... > Hi Guy's > > Can anyone help me out with the 2K version of the following plz. > > =IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)) > > This works great in 2007, but as with most things work related, they don't > have 2007 installed. > > TIA > Mark. > >
From: Noodnutt on 27 May 2010 18:47 All good peoples. Worked it out. It's always easier to see something clearer once you walk away and come back after a coffee. Cheers "Noodnutt @ Work" <markl(a)camerons.com.au> wrote in message news:eEiD%232d$KHA.1700(a)TK2MSFTNGP02.phx.gbl... > Hi Guy's > > Can anyone help me out with the 2K version of the following plz. > > =IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)) > > This works great in 2007, but as with most things work related, they don't > have 2007 installed. > > TIA > Mark. > >
From: Noodnutt on 27 May 2010 20:18 Cool Thx Fred Heaps better than my work-a-round. Cheers Mark. "Fred Smith" <fsmith11(a)yahooo.com> wrote in message news:eWQwZ0e$KHA.348(a)TK2MSFTNGP06.phx.gbl... > Average is Sum/Count, so use: > =IF($C8=0,0,SUMIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)/COUNTIF(Data!$AC$2:$AC$10000,"MAR-10")) > > Regards, > Fred > > > "Noodnutt @ Work" <markl(a)camerons.com.au> wrote in message > news:eEiD%232d$KHA.1700(a)TK2MSFTNGP02.phx.gbl... >> Hi Guy's >> >> Can anyone help me out with the 2K version of the following plz. >> >> =IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)) >> >> This works great in 2007, but as with most things work related, they >> don't have 2007 installed. >> >> TIA >> Mark. >> >> >
From: Fred Smith on 27 May 2010 21:55 Glad to help. Thanks for the feedback. Fred. "Noodnutt @ Work" <markl(a)camerons.com.au> wrote in message news:e9Ul8sf$KHA.5536(a)TK2MSFTNGP02.phx.gbl... > Cool > > Thx Fred > > Heaps better than my work-a-round. > > Cheers > Mark. > > > > "Fred Smith" <fsmith11(a)yahooo.com> wrote in message > news:eWQwZ0e$KHA.348(a)TK2MSFTNGP06.phx.gbl... >> Average is Sum/Count, so use: >> =IF($C8=0,0,SUMIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)/COUNTIF(Data!$AC$2:$AC$10000,"MAR-10")) >> >> Regards, >> Fred >> >> >> "Noodnutt @ Work" <markl(a)camerons.com.au> wrote in message >> news:eEiD%232d$KHA.1700(a)TK2MSFTNGP02.phx.gbl... >>> Hi Guy's >>> >>> Can anyone help me out with the 2K version of the following plz. >>> >>> =IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000)) >>> >>> This works great in 2007, but as with most things work related, they >>> don't have 2007 installed. >>> >>> TIA >>> Mark. >>> >>> >> > > >
|
Pages: 1 Prev: Find and Replace Next: Excel - Convert int value secs past midnight into time 53100=2:45 |