Tag Archives: Excel-Function

How to Sum or Count cells based on background color in Excel

Suppose during working on Excel, if you get a worksheet in which there are different kind of background colors in range of cells. Now if someone ask you how to sum or count cells based on background color in Excel. It is not an easy task to get the proper answer in quick way. In this guide we have to discuss how to sum or count cells based on background colors in Excel. Read More

What is Difference between SUMIF and SUMIFS Function

SUMIF function allows you to conditionally sum the values which match the given single criteria, While SUMIF is used to conditionally sum the values which match the multiple criteria. Most of the person little bit confused during using these functions. Today we have to discuss what is the difference between the SUMIF and SUMIFS function in Excel. Read More

How to Extract few Numbers using Excel Functions

Excel is a great application spreadsheet software which is used for complex calculations. During working on the Excel you can feed different kind of data. If you have any number is range of cells and want to extract few numbers using Excel functions. In this article we have to guide how to extract few numbers with the help of Value and Left functions in Excel. Read More

How to insert symbols and special characters in Excel

Excel is an important utility application software. It is used for data analysis, modelling, charting, calculations, apply lot of functions for complex calculation and many more. Sometime we need to insert symbols and special characters in Excel, but most of the symbols and special characters does not shown in your keyboard. Read More

How to use Solver command in Microsoft Excel

Solver is an another important utility of Microsoft Excel. With the help of solver you can easily find an optional value which is also called objective cell that satisfies all constraints and maximize or minimize the objective cell value. In this article we have to discuss how to use solver command in Microsoft Excel. Read More