Offset formula to add range depending on date

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi, I am trying to get a formula to sum a range of data up
to (and including) where the report date matches the
column date. I have got a statement which adds across
columns but I can't get the statement to add down rows to
work. I am trying the offset function for that. I have
a statement that adds down correctly but I can't figure
out the date part. (how to get it total all columns up to
(and including) the column which matchs the report date)

Can someone help?


Thanks,


Todd


Report Date: 11/3/97


11/2/97 11/3/97 11/4/97 11/5/97
3 9 27 81
4 10 28 82

=SUMIF($B$6:$E$6,$C$3,$B7:$E7) Adds across from where
report date matches column date (works great)

=SUM($B$7:OFFSET($B$7,0,0,2)) Adds down without regard to
date (needs to be date sensitive)
 
Sorry, I guess I didn't mark them well enough. Everything
is at the bottom of the first note. Here they are by
themselves. The rest is at the bottom.

=SUMIF($B$6:$E$6,$C$3,$B7:$E7)
=SUM($B$7:OFFSET($B$7,0,0,2))

Todd.
 
Back
Top