Excel Formula Help

[olds]

I want to average the totals in a column of 26 cells. I used =sum(C3:C28)/26
That works fine. But there must be a different way to do it without changing the formula if I need to add more rows.
TIA

 

[Haircut]

=AVERAGE(C3:C28)

You could also do =SUM(C3:C28)/COUNT(C3:C28), but since you can use average there really is no need 😛

 

[olds]

Originally posted by: Haircut
=AVERAGE(C3:C28)

You could also do =SUM(C3:C28)/COUNT(C3:C28), but since you can use average there really is no need 😛

Thanks. Will both of those work if a couple of more rows (C29, C30, C32, etc) are added?

 

[Haircut]

Yeah, average should work for any range you want.

 

[Bglad]

Sometimes if you add columns at the bottom or top of the column you have a formula for, it doesn't extend the formula out automatically. Ya gotta watch that.

 

[NeoV]

the trick is to insert a column into your range, not just add one at the end of your range...that way, any formulas at the bottom will automatically pick up the new rows..


For example, if your range of data is in rows 1 through 10, and your formula is in row 12 - if you need to add new info to your data range, instead of inserting a row just above row 12, insert a row(s) above row 10, and then the formula in row 12 will automatically expand to include as many new rows as you add..

 

[olds]

Thanks to all for the input.