Hi Domenic,

Thanks for reply. The Formula is not returning the desired result. It
returns zero.

Further help appreciated.

Cheers,
Sam



Domenic wrote:
Try...

=SUM(IF(SUBTOTAL(3,OFFSET(Data,ROW(Data)-MIN(ROW(Data)),0,1)),IF(Data=LE
FT(X$1,2),IF(Data<=RIGHT(X$1,2),1))))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

--
Message posted via http://www.officekb.com