| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Sum function dynamically
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add row dynamically | Excel Programming | |||
| Sum Column above current cell dynamically using function call | Excel Worksheet Functions | |||
| Function To Dynamically Display File Size | Excel Worksheet Functions | |||
| Dynamically pasting function from Visual Basic to Excel cell | Excel Programming | |||
Threaded Mode
