Updated: Jun 2, 2021
SUMIF Function is useful when you have a long list of specified cells you wish to find the total sum. I have created an Excel of Wallmart New Year Sale Result for this tutorial. We will also show you how to convert your SUMIF function in an API at the end of the video. Stay Tune.
Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download
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/
How to use the SUMIF Function in Excel? For this tutorial, I have created an Excel of Wallmart New Year Sale Result. These include Coffee, Sport Shoe, Pen and Book. Suppose you wish to learn the SUM function. We had made a video on it. Do check out the link above.
So, what is a SUMIF Function? A SUMIF function "Adds the cells specified by a given condition or criteria". For today's tutorial, let us sum the cells specified product of Coffee, Sport Shoe, Pen and Book. It is useful when you have a long list of specified cell you wish to find the total sum from.
How to use SUMIF Function
First, Select on the cell C23 and type in the equal, SUMIF, open parentheses. Select Cell B6 and drag your cursor to B21; click on F4 to make the range an absolute cell reference. Next, type in a comma and select our criteria which is Coffee on Cell B23 and type a comma. Lastly, we will be selecting our sum range, type in comma and move your cursor to Cell D6. Select it and drag your cursor to D21. Click on F4 to make the range an absolute cell reference. Close the parentheses and hit return. You will get a total sales for coffee are $1,634,928.
How to use AutoFill in SUMIF Function
Let us find the total sales for the remainder of the product, Sport Shoe, Pen and Book. Move your cursor to the lower right of C23. Once your cursor turns into the cross sign, double click on it. You will be able to see the total sales result for Sport Shoe, Pen and Book. This table is interactive and you can update the sales figure anytime you want. Let us update the Book Sales from $838,362 to $1039,362. Our total sum for book change from $1,886,448 to $2,086,448.
There you have it, the SUMIF 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 tutorial. 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 SUMIF function into Application Programming Interface (API)
I will be using AlchemyJ Studio Excel Add-in to turn this SUMIF Function Excel into an API. To do this, I will need AlchemyJ Excel installed and with a pre-set of rules. I will select the AlchemyJ ribbon, select Generate API and click on Generate API. The file is now converting. Okay, your API is ready.
I will now launch this openAPI which AlchemyJ generates, and try using the SUMIF Function on it. I will expand this tab and select try it out. Let us do a SUMIF of Coffee sales in the north of $2000, Pen sales in the south of $3000, Coffee sales in the east of $2000 and Book sales in the west of $1000. We should be getting a SUMIF of $4000 for Coffee. So, will we get it after I select the execute button? Yes, we got it.
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.