How to retrieve non-contiguous cell collections from strings in Excel?

microsoft-excel worksheet-function microsoft-excel-2007

Solution 1:

It works this way:

=SUM(INDIRECT("B4"),INDIRECT("B6"))

Related

Licensing issues when using a physical WinXP disk in VMware?
How to disable screens turn off Windows 8.1
Is it possible to install a discrete mobility card on a laptop without a graphics card already?
In Windows Command Prompt, how to get the last command that started with some letters?
Is there a way to control the volume of the Skype App in Windows 8.1?
Little size of windows on taskbar. How to fix it? [closed]
Is Windows 8 Pro Upgrade 32 bit or 64 bit
us keyboard, german layout - special character < and >
Cannot connect to wifi, but can connect through wire
How can I import Thunderbird mail folders into another instance of Thunderbird?
Shortcut in vs code to write input statement of java
Keep running into the same deployment error (Exec Format Error) when pushing Node.js Docker from local (Apple M1) to Heroku