simple runing average question

[jessfarnsworth]

I am trying to find a formula to calculate the running average for entire column of cells for all non zero values. I am using Gnumeric in linux and it is supposed to be Excell compatable. I have an averageif function but I cant figure out how to write the formula. I would apriciate any help you can give me.
Thank you

[gmr4evr1]

Not sure of your range, but try this....maybe......

Please Login or Register  to view this content.

[newdoverman]

I don't know what works with what you have so will give you two things to try.
With the values down column A starting in A1 enter this ARRAY formula in B1 and fill down: (enter with Ctrl + Shift + Enter)
1.

Please Login or Register  to view this content.

2.

Please Login or Register  to view this content.

	A	B	C	D	E
1	521	521	521	Column B	=AVERAGE(IF($A$1:A1>0,$A$1:A1))
2	0	521	521	Column C	=AVERAGEIF($A$1:A1,"<>0")
3	666	593.5	593.5
4	641	609.3333	609.3333
5	621	612.25	612.25
6	214	532.6	532.6
7	0	532.6	532.6
8	763	571	571
9	158	512	512
10	715	537.375	537.375
11	489	532	532
12	145	493.3	493.3
13	208	467.3636	467.3636
14	989	510.8333	510.8333
15	143	482.5385	482.5385
16	201	462.4286	462.4286
17	206	445.3333	445.3333
18	798	467.375	467.375
19	286	456.7059	456.7059
20	824	477.1111	477.1111

[jessfarnsworth]

THANKS
helped

[gmr4evr1]

Glad it worked out for you.

[jessfarnsworth]

yea its not perfect, i get a div/0 error if there is no data. And what i think i would like to do is apply it the whole column, if that makes any sense.

[jessfarnsworth]

HERE is what i am trying to do.
BLOOD SUGAR TRACKING

[newdoverman]

I can't open your files.
Here is the file that has both formulae working.

[newdoverman]

Managed to open your file, converted it to xlsx type

[jessfarnsworth]

cool.