Averaging numbers

[ShannonE]

i need to make a spreadsheet that averages numbers. but the amount of cells with data change from a week to week basis. For example i may use cells A1 to A5 to hold data in and A6 with the formula to average. I may use all 5 cells or I may use only 2. How can I tell excel to average those cells that only have data in them.

plz help, thx

[daddylonglegs]

AVERAGE function ignores blank cells so you can use

=AVERAGE(A1:A5)

If you want to ignore zeroes then try

=AVERAGE(IF(A1:A5,A1:A5))

confirmed with CTRL+SHIFT+ENTER

[ShannonE]

thank u very much. that was fast and easy.