Max, what do you see that I don't?
I would think this should be sufficient:
=IF(COUNT(2:2)<7,SUM(A2:AE2),.................
Biff
"Max" <[email protected]> wrote in message
news:[email protected]...
> And if there's the possibility that the number of historic data days in
> Sheet1's B1:AF1 is < 7 days from "today", and you want for such situations
> to just sum the available historicals up till and inclusive of "today"
> (notwithstanding it's less than the specified 7 days), we could put
> instead
> in Sheet2's A2:
>
> =IF(MATCH(TODAY(),Sheet1!$1:$1,0)-1<7,SUM(OFFSET(Sheet1!A2,,MATCH(TODAY(),Sh
> eet1!$1:$1,0)-1,,-(MATCH(TODAY(),Sheet1!$1:$1,0)-1))),SUM(OFFSET(Sheet1!A2,,
> MATCH(TODAY(),Sheet1!$1:$1,0)-1,,-7)))
>
> and copy down as before ..
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
>
>
>
Bookmarks