PAID and NOT PAID are the criteria in which the
sum is based i.e. the criteria argument.
C3:c7 is the range of cells that contain the value
you want add based on the specified criteria i.e. the sm_range argument.
Your worksheet should now look like the one in the figure
below.
CONCATENATE FUNCTION WITH ILLUSTRATION
This is an Excel built-in function used to join two or more
text items together.
The syntax for the CONCATENATE function looks like this: =CONCATENATE(TEXT1,TEXT2,TEXT3) press
Enter.
The function takes up to 255 text items. A comma is used to
separate each text item. If you actually a comma or a space or any special
character, you need to treat it as a text. If the item is a text, you enclose
it in double quote. A comma, space or any special character is treated as a text.
If the item is a number, or a formula, you don’t need to
enclose it in a double quote.
For example, the output of the CONCATENATE function:
=CONCATENATE(“Keyboard”,”=”,2,”
“,“Mouse”,”=”,3,” “,“Monitor”,”=”,4) is:
Keyboard=2 Mouse=3
Monitor=4
This is the end of the part 3 of chapter 2.
Now go over to Part 4: HOW TO CALCULATE YOUR CGPA USING MS-EXCEL
Was this tutorial helpful to you?
Inform your friends about this post by clicking the share button below.
Comment below if you are hooked up along the installation process.
Also click Here to subscribe for free so that you will get our latest game updates in your email.
No comments:
Post a comment
WHAT'S ON YOUR MIND?
WE LOVE TO HEAR FROM YOU!