Try this:

=AVERAGE(A1:INDEX(A1:L1,MONTH(NOW())))

--
Biff
Microsoft Excel MVP


"jcannon1" wrote in message
...
I am creating a spreadsheet that tracks our monthly goals for sales. My
spreadsheet looks like so:

Jan Feb Mar ETC
5000 5000 5000

I also have a portion for a YTD Average - I want the YTD average column to
pull the average based on the current month - ie if its February I want it
to
add Jan + Feb / 2.... if its March I want it to add Jan + Feb + Mar /
3....

Can anybody help me on this?