## Billing and debtors management utility for CA’s

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 Function in excel

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 »

## SUMIFS Functions in Excel

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 »

## How to use Excel SUMIF Formula

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 »

## Excel SUM Formula

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 »

## Using the \$ sign in excel formula to fix the cell reference

If you copy and paste a cell containing formula or drag the cell, the formula reference will also change and move accordingly. For example, if you want to calculate the amount of sales to each customer based on the number of units sold when the sales price is fixed, and… Read more »

## Hide error value in excel formula cells.

In Microsoft Excel, if the inputs are not valid, then the forula will show the error. This error may be like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.   To avoid this error, you can use the “ISERROR” or “IFERROR” formula. “IFERROR” is simple and easy, but this… Read more »