Help for Excel Beginner

Well Yes and no, it needs to have a way of knowing what month you are up to. If you have a cell with the month in that you can change, it can be used to update the formula

So lets say your month headings are in a3 to l3

in cell A1 you have the most recent month you could either type this or go to data validation and choose from list and select the range a3:l3 as the list, this would ensure you type the values conistently

then in your formula sum(a5:l5)/4 i have made it a full year

change to sum(a5:l5)/match($a$1,$a$3:$l$3,0)

the match matches the column heading and returns its position so thre fifth month returns 5. It does assume that the month names are unique, so April is A August must be something else eg Au

I hope that makes sense if not get back to me

Regards

Dav

Hi,

Sure there's a better way but this might help

=SUM($A$5:A5)/COLUMN()

Enter formula in say A6 and drag to the right.

The first A5 will be Static by the $'s and the other A5 will change to B5, C5 etc.
The Column() will enter a one for Column A. When you drag to B2 it returns 2 and so on

Hope it helps

VBA Noob

One step on

This is an array formula which needs to be entered with Ctrl + Shift + enter

Changes if A2 to A4 are Empty it returns a blank. Range range as required

=IF(A2:A4="","",SUM($A$5:A5)/COLUMN())

VBA Noob