Updated: Sep 29, 2021
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.
Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download
Excel Template: https://www.alchemyj.io/aj-excel-template
Learn More: How to setup AlchemyJ: https://www.youtube.com/watch?v=eTyYTf1sw9k&feature=youtu.be&ab_channel=AlchemyJ
How AlchemyJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ&ab_channel=AlchemyJ
Let's connect: LinkedIn: https://www.linkedin.com/company/alchemyj/
Do you know that SUM Function is not limited to a single sheet and can be used across multiple tabs? Amazing, isn’t it? For today’s Excel tutorial, I will be showing you 2 methods to calculate it. Without further ado, let us get started.
How to use SUM Function 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. We are given the total sales from January to December to find out the total sales.
In the first method, we will be adding the sum through the individual cell. Select Cell C4, type in equal, SUM, open parentheses. Move your cursor and select on Jan tab, select on Cell C4 and type in the “plus” symbol. Repeat the same step from February to December. Once you complete the step for December. Hit return. You will get the total sum of the north area Iphone 13 sales from January to December, which is $643,113. Let us do a quick auto-fill for the remaining cells. Lastly, we will do the SUM function to find the total sales for each and the total area.
In the second method, we will be using the ranges from January to December, instead of sum through individual cells. Select Cell C13, type in equal, SUM, open parentheses. Type in Jan, colon, Dec, exclamation mark and C4. Close parentheses and hit return. You will get $643,113, the same value as our previous example. Lastly, let's auto-fill and sum up the remaining cells.
There you have it, the SUM function for Excel. If you have any excel formula you want us to teach, let us know in the comment section below. Don't forget to subscribe, hit the bell button and turn on the notification to have more free excel function tutorials. But, before you go, we have a bonus clip for you. I will be turning this Excel spreadsheet into an API. Stay tuned to see how the magic works.
Convert SUM Function Across Multiple Tabs into Application Programming Interface (API)
I will be using AlchemyJ Studio Excel Add-in to turn this SUM function Excel into an API. To do this, I will need AlchemyJ Excel installed and with a pre-set of rules. I will select Generate API and click on Generate API. The file is now converting. Okay, your API is ready.
I will select the AlchemyJ tab and launch this open API that AlchemyJ generates. I will expand this tab and select try it out. I will input “six thousand, seven thousand, eight thousand and nine thousand 2 hundred and twenty-two”. Let us check if our SUM function is working? Awesome, we got thirty thousand two hundred and twenty-two.
AlchemyJ Studio Excel Add-in turns your Excel business model into API. This way, you can integrate your Excel model into other applications. You can download AlchemyJ Studio Excel Add-in for free at alchemyj.io. And once again, thank you for watching. So which Excel function you wish to be converted into an API? Let us know in the comment section below. Lastly, don't forget to subscribe, hit the bell button and turn on the notification. See you soon.