Sales Analysis Math form 7117

I have created an analysis with the col. that have sales by week for the last four weeks.

I know how to add the columns together but I would like to get an average. After I have my sum how do I divide by 4? If just type 4 it will use column 4. How do I differnetiate between “4” and column 4

Nav 6.0

Thanks in advance for all your help.

Instead of giving column no. as 1,2,3,4 rather no. them as A1,A2,A3,A4 etc. and then there will not be confusion.

And then in formula , write it as (A1…A4)/4 OR (A1+A2+A3+A4)/4

Hope this helps

That was just to simple :slight_smile:

Thanks againg Dhan