To find out the duplicate entries in a list, we can use the COUNTIF formula. The COUNTIF function counts the number of cells in a range which meets the given criteria. With the help of COUNTIF function we can find out how many times a given entry is appearing in… Read more »

Auto fill forms can be prepared in excel using linked picture option easily. If we prepare format of any form in excel, it will take lot of time and if it contains picture, logo and colours, it is difficult to align and set for print. To avoid this we can… Read more »

The shortcut keys will speed up the work by avoiding mouse clicks. Remembering these shortcut keys may be difficult, but by regular practice we can develop the habit of using short cut keys. Following are the 10 shortcut keys to speedup your work. 1 Ctrl+Space and Shift+Space these are the… Read more »

If you want to split the information in a cell and get only few number of characters in a particular cell you can use the simple functions like LEFT or RIGHT.LEFT: syntax for LEFT function=LEFT(text, [num_chars])LEFT function will give the number of characters given in the formula from left of the… Read more »

When the cash salary is to be disbursed to many employees, the currency of different denominations are required to make the payment. Some times currency notes of few denominations may not be available. Before making the payment the payer should be ready with the cash of required denominations. The Currency count… Read more »

New latest version of Invoice preperation utility in Excel July 31st is the last date for filing the Income tax return, when I requested my CA friend to file my tax return, in turn I received a request from him prepare a worksheet to prepare and maintain his billings. Based on… Read more »

VLOOKUP is the popular and widely used formula in MS Excel. VLOOKUP function searches given value ( lookup_value) in the left most column of the table and returns the value in the given column (col_index_num) of the matching row. The syntax for VLOOKUP is: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup_value: lookup_value … Read more »

SUMIF function is used to add the cells in a range which meets the given criteria. In SUMIF function you can give only one criteria. SUMIFS function adds the cells in a range which meets multiple criteria. Syntax for SUMIFS function is =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) The sequence… Read more »

In this article we have explained how to use Excel SUMIF Formula. Excel SUMIF function can be used to sum the value in a range that meets the given criteria. Syntax for Excel SUMIF Formula is: =SUMIF(range, criteria,[sum_range]) range is the argument that specifies the cells in which the criteria or… Read more »

SUM is one of the most commonly used function in Excel , which is used to add the numbers in the argument. In this article you can learn the syntax and how to use excel SUM formula. You can use this formula to add the numbers in a range by… Read more »