On Friday, November 3, 2017 at 12:51:54 PM UTC-6, Claus Busch wrote:
Hi,

Am Fri, 3 Nov 2017 11:33:22 -0700 (PDT) schrieb


Thanks for this. What if the values in a10 and b10 were numeric?

As in a10 and b10!was the relative column position

then try:
=SUM(OFFSET($A1,,$A$10-1,,$B$10-$A$10+1))


Regards
Claus B.
--
Windows10
Office 2016

great thanks that will work fine.