Do you know that SUM Function is not limited to a single sheet and can be used across multiple tabs? In our example, we are task to sum up the total sales for our new flagship phones: Iphone 13, Galaxy Z Fold 3, Galaxy Flip 3, Google Pixel 6, Huawei P50 in the North, South, East and West Area for 2021.
For today’s Excel tutorial, I will be showing you 2 methods to calculate it.
We will also show you how to convert your SUM function into an API at the end of the video.
Time Stamps:
"00:35": Method 1 - Individual Cell
"01:13": Method 2 - Ranges
"02:05": Convert SUM Function into Application Programming Interface (API)
Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download
Excel Template: https://www.alchemyj.io/aj-excel-temp...
Learn More:
How to setup AlchemyJ: • How to install AlchemyJ
How AlchemyJ works: • How AlchemyJ Works
Website: https://www.alchemyj.io/
Let's connect: LinkedIn: / alchemyj
On this page of the site you can watch the video online Basic Excel Function - SUM Function Across Multiple Tabs in Excel with a duration of hours minute second in good quality, which was uploaded by the user AlchemyJ 09 September 2021, share the link with friends and acquaintances, this video has already been watched 148 times on youtube and it was liked by 4 viewers. Enjoy your viewing!