Thread: Using Sum function dynamically
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Using Sum function dynamically
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
Reply With QuoteReply With Quote