Hi!

What are the dates in C13:Z13 ?

What are the dates in AY1 and AY2 ?

Biff

"rhani111" <rhani111.2cchri_1155248408.873@excelforum-nospam.com> wrote in
message news:rhani111.2cchri_1155248408.873@excelforum-nospam.com...
>
> 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),MATCH(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
>