“SUMIF”

The “SUMIF” function adds the contents of the cells if they satisfy a certain condition.
An example:
I want to know the number of units sold per product.

I’m going to do this using the function wizard, so I click the “Insert Function” button to the left of the formula bar.
Choose the “SUMIF” function from the list, and click OK
In the first section of the dialog box that appears, specify the range in which all my sold products are listed.
In the second box, the condition, in this case cell G3, in which the product is placed.
In the third section I enter the range where all my product sales are listed.

I click OK when I’m done.
Result:

If you want to copy the formula down, you should make it as an absolute cell reference, with the exception of the cell G3.
This should automatically be adjusted when we copy this formula down.

“CONCATENATE”

With the “CONCATENATE” function, we can merge text from different cells.
To merge text from different cells, first choose an empty cell, and then click the downward pointing arrow next to “Text” in the “Formula” tab in the “Ribbon”.

This opens a drop-down menu where you choose “CONCATENATE”.
In the dialog box that appears, enter the cell reference you want to use for your first text, in the first box.
Select the second field and type a space between quotation marks.
This inserts a space between the various texts we merge.
In the third field specify the cell reference of the second text.

Click OK.
The text in cell F2 is now merged with cell G2.
Double click the fill handle if you want to copy this formula to the underlying cells.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats