How to use RIGHT function in MS EXCEL | Learn MS Excel | Free courses | Learn online | Excel string functions

The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string.

🆂🆈🅽🆃🅰🆇

RIGHT (text, [num_chars])

🅰🆁🅶🆄🅼🅴🅽🆃🆂

text - The text from which to extract characters on the right.

num_chars - [optional] The number of characters to extract, starting on the right. Optional, default = 1.

It can also be applied on numbers.

In the example the 2nd argument not mentioned, so extracting only single character from right.

When supplied with any number more than the number of characters in the given text string, it will return the whole text string.

Often RIGHT function used with Left Function to extract first, middle and last name from a name field.

If you have any questions, write to me at dataentryikc@gmail.com

How to use LEN function in MS EXCELLENT | free course on Excel | Learn online | Excel string functions

The Excel LEN function returns the length of a given text string as the number of characters.

It is one the most useful excel string functions, used many times to achieve our objective.

LEN will also count characters in numbers.

Syntax

LEN (text)

Arguments

text - The text for which to calculate length.

It is often used with Right and Left function in MS Excel to separate First, Middle, and Last Name from a given name.

In the example, the LEN function is used to determine the number of characters in a name including spaces.

The same function also applied on numbers to count how many numbers are there in the field. If spaces or special characters or any text included it will also count them together.

Have any questions? Write to dataentryikc@gmsil.com

How to use COUNTIFS function in MS EXCEL | free course on MS EXCEL | Learn for free | Learning is fun

The Excel COUNTIFS function returns the count of cells that meet one or more criteria. COUNTIFS can be used with criteria based on dates, numbers, text, and other conditions.

Syntax

COUNTIFS (range1, criteria1, [range2], [criteria2], ...)

Arguments

range1 - The first range to evaulate.

criteria1 - The criteria to use on range1.

range2 - [optional] The second range to evaluate.

criteria2 - [optional] The criteria to use on range2.

Let us try to understand with an example.

Here we have used COUNTIFS function to extract the number of students studying in section "A" with marks in Math >60 and marks in Physics >60

In this way multiple conditions can be imposed but the length of range in all conditions must be same.

How to use MATCH function in MS EXCEL

MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching. MATCH is often combined with the INDEX function to retrieve a value at a matched position.

Syntax

MATCH (lookup_value, lookup_array, [match_type])

Arguments

lookup_value - The value to match in lookup_array.

lookup_array - A range of cells or an array reference.

match_type - [optional] 1 = exact or next smallest (default), 0 = exact match, -1 = exact or next largest.

In the example the MATCH FUNCTION is used to fetch the position of the searched value in the table. Here the 3rd argument is set to "0" for exact match.

Note here the function is not case sensitive. Also please note that the table contains repeated values. The MATCH function brings out the first occurence of matching.

How to use INDEX function in MS EXCEL

The Excel INDEX function returns the value at a given position in a range.

INDEX function is often used with the MATCH function.

Syntax

INDEX (range, row_num, col_num)

Arguments

range - A range of cells.

row_num - The row position in the range of cells.

col_num - The column position in the range.

In the example, the INDEX function is used to fetch the values of row 1 of the table and column no. 1

Similarly the other row and column values can be fetched by changing the row and column numbers.

NOTE: The range is taken as absolute reference by putting "$" sign in the range as "$A$62:$C$72" as we are refering the same range again and again.

So now you know how to use INDEX function in MS EXCELLENT. If you have any questions, feel free to contact at dataentryikc@gmail.com

How to use SUMIF function in MS EXCEL

The Excel SUMIF function returns the sum of cells that meet a single condition.

Criteria can be applied to dates, numbers, and text.

The SUMIF function supports logical operators (>,<,<>,=).

Syntax

SUMIF (range, criteria, [sum_range])

Arguments

range - The range of cells that you want to apply the criteria against.
criteria - The criteria used to determine which cells to add.
sum_range - [optional] The cells to add together.

The example shows the use of SUMIF in summing up the sales quantities for year >2012.

The SUMIF function is used again to calculate the total sales quantity as per each category.

In another example SUMIF function is used on date. We enter the enquiry date and the function calculates the total sale quantities on and after the enquiry date.

Now you know how to use SUMIF function. If you have any questions feel free to contact me at dataentryikc@gmail.com

I will be happy to help you. 👍👍

I am a freelancer specialized in Data entry, Lead generation, QR code design, Letterhead design

Hi, I am

Indranil Kar Chowdhury

ABOUT ME

Indranil Kar Chowdhury

My Professional Skills

Services

Typing

Data entry in MS Excel/Google spreadsheet

Custom QR code Generation

Lead Generation

Data Scrapping

Why me ?

Portfolio