Summing the last 200 days

  • Thread starter Thread starter Louja
  • Start date Start date
L

Louja

Hi,

I was wondering if anyone could help me - I need to add up the 200
most recent days for a spreadsheet and was wondering rather than
messing with cut and paste if there was a formula that could do it all
for me. I will have more than 200 days worth of info.

Also the sheet I am adding up on has gaps between the weeks so its not
just a matter of copying the formula over.

Thanks!
 
Louja,

If you want the last 200 days of data - assuming one data point per day:

=SUMIF(A1:A1000, ">=" & LARGE(A1:A1000,200), B1:B1000)

Or within the last 200 days:

=SUMIF(A1:A1000, ">=" & TODAY()-200, B1:B1000)

HTH,
Bernie
MS Excel MVP
 
Back
Top