Categories
Excel Microsoft Office

Excel Functions: SUM, SUMIF and SUMIFS

There are many functions in Excel to do the addition of numbers in two or more cells. Of all these functions in Excel to add values, the most widely used functions are: SUM, SUMIF and SUMIFS. Let’s understand more about these functions and learn how to use them in Excel.

I’ve created a table in Excel that you can see in the image below, you can also create a table like this. We’ll use the SUM functions on this table.

SUM( )

When we have to add two or more numbers without any condition, we will use SUM( ).

Example:

In the table above, if we have to find total Sales amount, we’ll use:

= SUM(F3:F7)

The result will be ₹ 98,200.00

SUMIF( )

SUMIF function will add only those numbers in the cell range that match with the one condition we enter in the function.

Please note: The condition will be on the same column on which addition will be performed.

Example:

If we have to add only those Sales amount, that are more than ₹ 10,000.00 then we’ll use SUMIF as:

=SUM(F3:F7,”>10000″)

The result will be ₹ 87,000.00

SUMIFS( )

In SUMIFS function, we can give condition using multiple columns.

Example:

If we have to add only those amount, that are from Fashion category and also from Clothing sub-category, then we’ll use SUMIFS as:

=SUMIFS(F3:F7,D3:D7,”fashion”,E3:E7,”clothing”)

The result will be ₹ 1,500.00

I have also included all the formula below the table so that it can be easy for you to understand the difference in the functions.

I hope the above article was helpful for you to understand the SUM, SUMIF and SUMIFS functions in Excel. If you’ve any doubt, please share it through comments.

Categories
Excel Microsoft Office Word

How to Use Excel Spreadsheet in Word

There are many times, we use Excel to create table, charts and then copy them to a Word document for our project report. Going to Excel, doing copy and paste for every time will definitely take our time and this time can be saved, if we can open Excel inside Word. Wouldn’t you feel glad if you can do that? I’m sure you would.

Microsoft Word allows you to work in Excel spreadsheet without you opening Excel application. You can do calculation, create table, create charts etc. without going to the process of opening Excel.

How would you that? Don’t worry. We’ll see that in this article now.

After you’ve opened Microsoft Word document, to use Excel sheet in Word:

  • Go to Insert tab, click Table and click Excel Spreadsheet.
  • You’ll find Excel sheet added in the Word document, also the Excel tabs at the top.
Excel Spreadsheet in Word document
  • Now, you can do calculation, create charts etc. like you do in Excel.
Chart created in Excel sheet inside Word
  • Once you have done your work in the sheet, click outside the sheet area, and you’ll be back with Word tabs.