Menu

Using Sum function dynamically

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add row dynamically	Gotroots	Excel Programming	15	December 11th 09 12:57 PM
Sum Column above current cell dynamically using function call	TopSlice	Excel Worksheet Functions	7	September 15th 09 02:03 PM
Function To Dynamically Display File Size	MDW	Excel Worksheet Functions	1	February 16th 06 09:45 PM
Dynamically pasting function from Visual Basic to Excel cell	John Fejsa	Excel Programming	0	February 9th 04 11:45 PM

All times are GMT +1. The time now is 05:32 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement