Formula help please

  • Thread starter Thread starter jfe4245
  • Start date Start date
J

jfe4245

I have created a spreadsheet to track sports schedules and stats.
On one sheet I have a column of cells that using the Countif function I
track wins and losses. I would like to have a formula, function, macro or
something that will automatically update say the last 10 entries in the
column.

Is there such a thing?
 
Is there such a thing?

Probably, but you need to explain what you want to do with the values in the
last 10 cells. for example this sums the last 10 non-zero cells in A1 - a1000

=SUM(INDEX(A1:A1000,LARGE(ROW(A1:A1000)*(A1:A1000<>0),10)):A1000)

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike
 
Back
Top