Tag Archives: Microsoft-Excel

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 Copy Formatting only using Fill Handle in Excel

Fill Handle is an important tool of Microsoft Excel. You can easily and quickly copy, extend the data series or formatting on rest of the cells. Fill handle is an important tool which helps you to do this job. In this article we have to discuss how could you copy formatting only using Fill handle 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