J
jcannon1
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?
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?