Average using Sumproduct or ....
in [General]
|
Prev: Conditional Format a range based on 1 cell
Next: IF
From: RagDyeR on 15 Apr 2010 12:10 Ever given any thought to writing something on Frequency(), similar to what Bob did with SumProduct()? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "T. Valko" <biffinpitt(a)comcast.net> wrote in message news:ubyw7$12KHA.1708(a)TK2MSFTNGP05.phx.gbl... See your other post http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.misc&p=1&tid=d733c201-577a-40ed-bb9d-60b9609a8e90 -- Biff Microsoft Excel MVP "heater" <heater(a)discussions.microsoft.com> wrote in message news:E6A200BC-61BF-4FFD-8A66-24BB9D8B5471(a)microsoft.com... >I have 12 tabs (same worksheet) that I need to average a number in cell b6. > The issue is sometimes there is a zero in b6 and I do not want to count it > in > the average. example: tab 1, b6=145, tab 2=276, tab 3=0, tab 4= 123, tab > 5=0, and so on... What is a good formula?
From: T. Valko on 15 Apr 2010 19:04 I need a website! -- Biff Microsoft Excel MVP "RagDyeR" <ragdyer(a)cutoutmsn.com> wrote in message news:uU0MhYL3KHA.4336(a)TK2MSFTNGP04.phx.gbl... > Ever given any thought to writing something on Frequency(), similar to > what > Bob did with SumProduct()? > > -- > > Regards, > > RD > ----------------------------------------------------------------------------------------------- > Please keep all correspondence within the Group, so all may benefit ! > ----------------------------------------------------------------------------------------------- > > "T. Valko" <biffinpitt(a)comcast.net> wrote in message > news:ubyw7$12KHA.1708(a)TK2MSFTNGP05.phx.gbl... > See your other post > > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.misc&p=1&tid=d733c201-577a-40ed-bb9d-60b9609a8e90 > > -- > Biff > Microsoft Excel MVP > > > "heater" <heater(a)discussions.microsoft.com> wrote in message > news:E6A200BC-61BF-4FFD-8A66-24BB9D8B5471(a)microsoft.com... >>I have 12 tabs (same worksheet) that I need to average a number in cell >>b6. >> The issue is sometimes there is a zero in b6 and I do not want to count >> it >> in >> the average. example: tab 1, b6=145, tab 2=276, tab 3=0, tab 4= 123, >> tab >> 5=0, and so on... What is a good formula? > > >
From: RagDyeR on 15 Apr 2010 22:13
True, but maybe something like: http://www.oaltd.co.uk/MVP/Default.htm -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "T. Valko" <biffinpitt(a)comcast.net> wrote in message news:uCm20$O3KHA.1016(a)TK2MSFTNGP02.phx.gbl... I need a website! -- Biff Microsoft Excel MVP "RagDyeR" <ragdyer(a)cutoutmsn.com> wrote in message news:uU0MhYL3KHA.4336(a)TK2MSFTNGP04.phx.gbl... > Ever given any thought to writing something on Frequency(), similar to > what > Bob did with SumProduct()? > > -- > > Regards, > > RD > ----------------------------------------------------------------------------------------------- > Please keep all correspondence within the Group, so all may benefit ! > ----------------------------------------------------------------------------------------------- > > "T. Valko" <biffinpitt(a)comcast.net> wrote in message > news:ubyw7$12KHA.1708(a)TK2MSFTNGP05.phx.gbl... > See your other post > > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.misc&p=1&tid=d733c201-577a-40ed-bb9d-60b9609a8e90 > > -- > Biff > Microsoft Excel MVP > > > "heater" <heater(a)discussions.microsoft.com> wrote in message > news:E6A200BC-61BF-4FFD-8A66-24BB9D8B5471(a)microsoft.com... >>I have 12 tabs (same worksheet) that I need to average a number in cell >>b6. >> The issue is sometimes there is a zero in b6 and I do not want to count >> it >> in >> the average. example: tab 1, b6=145, tab 2=276, tab 3=0, tab 4= 123, >> tab >> 5=0, and so on... What is a good formula? > > > |