Forum Discussion
AVERAGING
Very simple formula, to average daily. Start with b1:b2/2, b1:b3/3, b1:b4/4. Doing Monthly average and a Yearly total over ever-increasing days. Researched and identified a formula that might wor...
Start with =AVERAGE(B$1:B2) and then fill down. The $ sign "fixes" the row number 1, so it will stay the same.
- Hans
Applied the $ into formula and it worked.
Most grateful for your assistance
Brian
