counting last seven in row

  • Thread starter Thread starter judoist
  • Start date Start date
J

judoist

I have a database with a row of numbers. A new number is added to th
row every day. Does anyone know what to use so that the last seve
digits are counted each time without me having to constantly adjust th
formula
 
Hi
if you mean summing these values and if you don't have any blank rows
in between try:
=SUM(OFFSET($A$1,COUNTA(A:A)-1,0,-7))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum the last seven days? 4
Formula for counting number of blank cells in spreadsheet by row 1
counting blank cells within two columns 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Count with conditions? 8
Count help with numbering Rows? 2
Excel Count Problem 1
Count number of days from the last entry? 2

Back
Top