Summing the last 200 days
 

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!

Summing the last 200 days
 

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


"Louja" wrote in message
...
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!