#REF! error issue

[contaminated]

Hi
Dont know why, but I get #REF! error. Enter this formula on a blanc sheet, say in A1

Please Login or Register  to view this content.

Actually the numbers in OFFSET formula are output of other formulas. As the result it MUST sum B6:F6 range... but it doesn't.... Gotta say that I understand OFFSET function but not in this case

[DonkeyOte]

Your range is 0 rows high.

[contaminated]

I always say u'r masterful....
Thx great...