Friday, 27 June 2014

COUNTA Formula Excel with Example.

How to use COUNTA Formula in MS Excel / COUNTA Formula With Example/ Function with Example in Microsoft Excel.


Every Excel user should have knowledge / information about COUNT Function, as COUNTA Formula is a very important formula in MS Excel. In this Example we will learn What exactly COUNTA Formula do in Excel or How to use COUNTA Formula in MS Excel? Also what is the Difference between COUNTA & COUNT Formula?




COUNTA Function or COUNTA Formula counts the number of cells in a range that have data in them. If you+ want to count the number of cells that contains data, then COUNTA function / formula will be used. COUNTA Formula can be used in Microsoft Excel 2003, 2007, 2010, 2013 or any version of Microsoft Office MS Excel.

Difference between COUNTA & COUNT Formula in Excel:-

As we already discuss about COUNT Formula, COUNT Formula counts cells only that contains numbers not any other data but COUNTA formula counts all the cells that contains data either the data is numeric (Number) or any other data type.

What is the SYNTAX of COUNTA Formula in Excel?

SYNTAX:- =COUNTA(range) or =COUNTA(value1, value2....valueN)

NOTE:- COUNTA counts all cells that have any data, if you want to count only cells that contains numeric (number) values then use COUNT formula instead of COUNTA.

COUNTA Example:-

We have a data that contains some data doesn't matter what is the type of data either it's numeric or any other type, COUNTA formula will simply count the cells that contains any type of data. Below is an example:-
COUNTA Formula Excel
Please give your suggestions and comments in comment box. Thanks.

Thursday, 26 June 2014

TRIM Formula with Example MS Excel

TRIM Formula Excel / How to use Trim Function in MS Excel / Use of TRIM Formula in Microsoft Excel Spreadsheet / TRIM Example Excel.




There is a Formula in Microsoft Excel Software, TRIM Formula. TRIM Formula is a very interesting and useful formula in MS Excel. Here we will learn how to use TRIM Formula with Example? In this Formula we will use LEN Formula for the better understanding of TRIM Formula.

Where we use TRIM Formula, How to use TRIM Formula in Excel and What is the TRIM Formula Syntax in Microsoft Excel Software?

TRIM Formula Syntax:-  =TRIM(text) or =TRIM(cell reference)


Sometimes we get double spaces in our data and we wants to get rid of any double space in a cell, except for single spaces between words. There are some situations when you pull data from a database or you get data from other sources and for some reason extra spaces are put in behind or in front of proper data, in that case TRIM formula is extremely useful. So, to remove extra spaces (more than one space in a cell), spaces after the data or spaces before the data TRIM function is used.

Example of TRIM Formula:-

We have a sentence in cell B2 (Just for an example) and sentence has more than one space in between the sentence and once space before the starting of the sentence and one space after the sentence, so to remove all more than 1 space in between the sentence, spaces before sentence and spaces after the sentence, we will use TRIM formula in cell D3 and Result in D4.
TRIM Formula Image
To know how TRIM Formula works in Excel worksheet, we will use LEN Formula to know the character count before the TRIM Formula and to know the character count after TRIM Formula.
Know about LEN Formula in MS Excel, CLICK HERE.

Wednesday, 25 June 2014

COUNT Formula Excel / How to use COUNT Function in MS Excel.

COUNT Formula with Example in Microsoft Excel / How to use COUNT Formula in MS Excel / Microsoft Excel (MS Office) COUNT Function / Formula.


In MS Excel, COUNT Formula is a very important formula. Every Excel user should have knowledge / information about COUNT Function. What exactly COUNT Formula do in Excel or How to use COUNT Formula in MS Excel with Example?

COUNT Function or COUNT Formula counts the number of cells in a range that have numbers in them. If you want to count the number of cells that contains data* (only Numeric Data), then COUNT function / formula is used. COUNT Formula can use in Microsoft Excel 2003, 2007, 2010, 2013 or any version of Microsoft Office MS Excel.

What is the SYNTAX of COUNT Formula in Excel?

SYNTAX:- =COUNT(range) or =COUNT(value1, value2....valueN)


NOTE:- Remember that COUNT Formula in MS Excel Counts only those cells that contain Numbers (Numeric Data).

COUNT Example:-

We have a data and we want to know the count of number cells within the data range. Lets say, We have some data from A2 to A11 (A2:A11) and we want to know the count of cells that contains numbers, then we will use COUNT Formula. See below:-
Count Example
In Example 1, there are two values which are not numbers so COUNT Formula count only 8 rather than 10.

In Example 2, All values are numbers (Numeric values) so COUNT Formula counts complete cells within the range E2:E11.


Tuesday, 24 June 2014

SUMIF Formula MS Excel / How to use SUMIF Function in MS Excel.

Excel SUMIF Formula / SUMIF Function in Microsoft Excel / How to use SUMIF with Example in Excel Worksheet. SUMIF Formula Syntax Excel.




SUMIF is a very powerful formula in MS Excel. The use of SUMIF is very high in Companies. SUMIF is not so tough as it looks like. It's a very easy to use and important formula in Excel. Every Excel use should have knowledge about SUMIF Function. SUMIF Formula works in all MS Excel Versions like MS Office 2003, 2007, 2010 etc. Here we use SUMIF Formula with Example.

The SUM Formula in Excel simply count two or more values, but if an excel users wants the sum of a specific value in a specific range then SUMIF formula will be used. So, how to use SUMIF Formula / Function in Excel? Here we will learn SUMIF formula with example.

What is the Syntax of SUMIF and How to use SUMIF Formula in Excel Spreadsheet?


SUMIF Formula / Syntax:- =SUMIF(range, criteria, [sum_range]).

Range:- Cells range to be evaluated.
Criteria:- the condition or criteria which will be in the form of a number, expression, or text that defines which cells will be added.
sum_range:- the actual cells to sum.

SUMIF Sample Data
NOTE:- If sum_range ommited(leave blank) the cells in the range are used as sum_range.

SUMIF formula Example:-

Suppose we have a data of salespersons, target, total sale, and status for target achieve or not, now if
we have to calculate the total sale of those salespersons who had achieved their target then we will use SUMIF formula, below is SUMIF Example:-


Here we want to sum of the total sale for those salespersons who had completed their targets (those whose total sale value is greater than 600 rs.).
SUMIF Formula with Example

Here is the result for those salesperson who have completed for their targets 8199 rs (Sum of Total sales of the salesperson those who have total sale greater than 600).

In the above formula:-

Range is D2:D21
Criteria is D2
Sum_Range:-C2:C21

SUM Formula with example in MS Excel / Excel SUM Formula

SUM Formula with Example in MS Excel / MS Excel SUM Function / Difference between SUM & SUMIF formula / Function in Microsoft Excel.

In Microsoft Excel SUM Function or Formula is a very useful formula or function. With the help of SUM Formula in MS Excel Excel users can calculate / find the SUM of given Numbers. SUM Formula works in all MS Excel Versions like MS Office 2003, 2007, 2010 etc. Here we use SUM Formula with Example.



The SUM formula does exactly what you would expect or want. SUM formula allows you to add 2 or more numbers together very quickly and in a very simple way. You can use cell references (Give values from cells) as well in SUM formula.

What is the SUM Formula in MS Excel?

Formula:- =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5

Now here we add two numbers and numbers with cell reference in excel. You can use Excel as a calculator for mathematical functions. SUM is an example of mathematical functions.
Lets say you have two values and want to add both the values just type =SUM(value1, value2, .......valueN) and you will get the summation of the values / numbers. Instead of entering values or numbers in the formula you can also give cell references if you have data in your Excel Sheet / Table cells and you want to add those numbers / values.
Excel SUM Formula with Example
Instead of typing SUM Formula you can simply adding two or more values by putting + sign between two or more values in MS Excel worksheet or Excel Table after = equal to sign.

There is a another SUMIF Formula / Function in Excel. SUMIF is little different from SUM.

What is the Difference between SUM & SUMIF formula?

There is little difference between SUM & SUMIF Formula in Excel. In SUM Formula you don't need to give any range or range criteria, it adds simply numbers as given. In SUMIF Formula you can give a specific range, criteria you want. SUMIF formula adds the cells specified by given condition and criteria. SUMIF Formula:- =SUMIF(range, criteria, [sum_range]).

To Know Excel Shortcuts CLICK HERE.

Sunday, 22 June 2014

LEN Formula with Example in MS Excel

How to Find Lenght of Characters in a cell in MS Excel? Len Function Microsoft Excel. Get No of Characters in a cell in Excel. LEN Formula with Example in Excel 2007.



Len Formula / Function is a very useful formula in MS Excel. Len Function gives the character lenght or we can say counts the character in a cell in MS Excel. The LEN Formula counts the characters present in a cell with spaces in Microsoft Excel. Sometimes we need to put a specific lenght of characters in a data, in that case we need find the number of characters / letters in Excel cells, then we use LEN Function.

LEN Formula in MS Excel:- =LEN(CellValue)


LEN Formula with Example:-

We have some addresses in cell A2:A9 and we want to find out the lenght of characters present in these cells.

Write the LEN formula (=LEN(A2)) in cell B2 and press Enter.

Now Fill the formula till the end of the data (A9), and you will get the count of characters available in cells.

NOTE:- LEN Formula counts all the spaces and special characters too.

Tuesday, 17 June 2014

MCD Delhi Junior Engineer Recruitment 2014 / JE (Civil) & JE (Elect.) Recruitment MCD 2014

MCD (Delhi Municipal Corporation) Junior Engineer Recruitment- Delhi Government Job 2014- MCD Delhi Govt Jobs 2014.

MCD Delhi Recruitment of JE (Civil) & JE (Elect.) through online Applications / Delhi MCD Junior Engineer Govt Job 2014




Delhi Municipal Corporation (MCD) issued notification for recruitment of 35 junior engineer (Civil and Elect.) posts for New Delhi location. Those who holds Graduation degree in Civil Engineering with 2 years of experience after graduation are eligible to apply for these latest Government Central Job 2014. Candidates who got selected in MCD (Delhi Municipal Corporation) Recruitment 2014 will have pay scale of Rs 9300-34800/- with appropriate grade pay of Rs 4200/-.

Delhi Municipal Corporation Notified Recruitment to fill up vacant posts on contractual basis, according to the employment news. All the eligible candidates who are looking / seeking for Junior Engineer Job position or interested in applying for MCD (Delhi Municipal Corporation) Recruitment 2014 can apply online to these positions online through the MCD official website i.e www.mcdonline.gov.in. Last date for the submission of online applications form for Junior Engineer in MCD is 23rd June 2014. The candidates selection for the recruitment will be based on the test/interviews. Applications will not be accepted after the mentioned dates, so interested candidates should apply / fill online applications on or before the last date in official website of MCD.

  

To Fill Online Application Form for Junior Engineer Post in MCD Delhi-Click Here.

Important Details regarding MCD-Delhi Municipal Corporation notification 2014 are mentioned below. 

Delhi Municipal Corporation Recruitment 2014 Details:


Name of the Organization:- Delhi Municipal Corporation (MCD)
 

Official Website of MCD Delhi:- www.mcdonline.gov.in
 

Job Category:- Government Job (Delhi Government Job)
 

Job Role:- Junior Engineer 
No of Vacanies in Delhi MCD:- 35
 

->In 35 vacancies 18 post is for General, 08 for OBC, 05 for SC, 03 for ST and 01 for Others.
 

Job Location:- New Delhi