Would sks please help me (a real newby to excel) to calculate the average inflation rate for the period shown assuming 3.8% is A1 and 2.8% is G1 please. I can do the first bit, ie =sum(a1:g1) but surely the correct formula is not =sum(a1:g1)/7 I am guessing that counting the rows is counterproductive but I just can't get the second bit. 3.8% 1.5% -0.8% 0.0% 2.0% 3.9% 2.8%
TIA, regards Chris