Hi Domenic,

Thank you very much for your assistance. It worked a treat!

=SUMPRODUCT(--(Data=InputCell_DB),SUBTOTAL(3,OFFSET(Data,ROW(Dat a)-MIN(RO
W(Data)),InputCell-1,1)))

I also tried again, the original posted version that gave me #VALUE! error;
I must have had a typo in the Formula on my worksheet because it now returns
the correct value! No error.
I think I had extra parenthesis in my worksheet version.

=SUMPRODUCT(--(Data=InputCell_DB)*(SUBTOTAL(103,OFFSET(INDEX(Dat a,1,1),ROW
(Data)-MIN(ROW(Data)),InputCell-1,,))))

Thanks again.

Cheers,
Sam

Domenic wrote:
Try...

=SUMPRODUCT(--(Data=InputCell_DB),SUBTOTAL(3,OFFSET(Data,ROW(Dat a)-MIN(RO
W(Data)),InputCell-1,1)))

Hope this helps!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200709/1