View Single Post
  #1   Report Post  
SunriseCea
 
Posts: n/a
Default How to sum the last 5 non-blank cells in a row?

I want to sum weekly scores where the last 5 are added then the lowest
removed. Some people have a zero value (away that day), so we need to add
the last 5 non-blank cells then deduct the minimum value (that is greater
that zero)