“Excel can do magic stuff”

1 SUM a column in Excel.
To SUM a column that has data that is not in numeric format.

The 'numbers' you are trying to add are Texts, not numbers. When using the standard SUM function the answer will get "0".

One option is to combine this in an Array-formula: instead of =SUM(E10:E13) use =SUM(VALUE(E10:E13)) and press CTRL,SHIFT,ENTER (instead of only ENTER).
The result will display as ={SUM(VALUE(E10:E13))} even though you never typed the {}.

2 VBA in Excel.
1 Open VBA Editor: Press ALT + F11.
2 Open Immediate Window: Press CTRL + G (optional, for debugging)
3 Insert a New Module: Go to Insert > Module.
4 Write your code.
5 Run This VBA Code

3 VBA JSON Parser in Excel.

Useful for extracting data from web sites.
VBA does not have built-in JSON parsing support.
You need to add a JSON parser to your VBA project.

1 Download the parser 'JsonConverter.bas' file from GitHub
2 Import the JSON Parser into VBA
3 Open the VBA Editor
4 Go to File > Import File
5 Select JsonConverter.bas and click OK.

To use these Json scripts Microsoft Scripting Runtime has to be enabled.

4 VBA Scripts in Excel.

Enable "Microsoft Scripting Runtime"
1 In VBA Editor, go to Tools > References
2 Scroll down and check ✅ Microsoft Scripting Runtime
3 Click OK
4 Run your Code