Hi All,

Just wondering if anyone can tell me how to do this....I was helped
recently by an awesome guy in the UK with a formula, but it won't
calculate between the dates. It will only see if there are matching
dates and then return values that appear between them, but I need it to
return values if ON the date specified or between the dates. If there is
no end date.....only count between the start and end date.

here is the formula he gave me...

=SUM(OFFSET($C$196,MATCH(A197,$A$197:$A$203,0),MAT CH(AY1,$C$13:$Z$13,0)-1,1,MATCH(AY2,$C$13:$Z$13,0)))

C196 being where the data begins
A197 is the first value to match between A197 and A203
AY1 is the start date
C13:Z13 is where the dates appear (not in any specific order)
AY2 is the end date

Thanx all
Rhani


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=570557