Excel Functions

Excel COUNTIF to Count Cells Greater Than 1 (2 Examples)

In Excel, sometimes we need to find the values that are greater than 1. If we work with a small dataset, we might be able to do it manually. But for ...

How to Use the Combination of COUNTIF and SUMIF in Excel

COUNTIF and SUMIF are two of the most effective and versatile functions in Excel.  The COUNTIF and SUMIF functions are attributed to conditional ...

Advanced Use of COUNTIFS Function in Excel (9 Examples)

The COUNTIFS function is a built-in function of Excel. It is more advanced than the COUNTIF function. The COUNTIF function satisfies only one ...

[Fixed!] Excel VLOOKUP Not Returning Correct Value

Excel VLOOKUP function is a very useful function. You can find out your needed data from a big range of data easily by using the VLOOKUP function. ...

How to Use Excel COUNTIF Between Time Range (2 Examples)

Excel COUNTIF function is used to count based on criteria. We can set criteria according to our requirements. Time range is one of the criteria. In ...

How to Use COUNTIF Function In Excel to Count Bold Cells

In this tutorial, I am going to share with you step-by-step methods on how to use the COUNTIF function to count bold cells in Excel. You can easily ...

[Solved!]: Excel COUNTIF Returning 0 Instead of Actual Value

Excel COUNTIF function counts values that match criteria from a range. You may sometimes face the issue that the function is returning 0. Today, in ...

VLOOKUP Not Picking up Table Array in Another Spreadsheet

The VLOOKUP function is one of those functions we use in Microsoft Excel on a regular basis to find information on a large spreadsheet. But like any ...

How to Copy VLOOKUP Formula in Excel (7 Easy Methods)

VLOOKUP stands for vertical lookup. When we need to search for any value from a table or range based on a reference in Excel, use this VLOOKUP ...

How to Use SUMIF, COUNTIF and AVERAGEIF Functions in Excel

Dealing with a set of data consisting of texts as well as numerical values of a company or an organization, it is a common scenario to feel the ...

Count Text at Start with COUNTIF & LEFT Functions in Excel

Counting text or characters is a very common phenomenon among regular Excel users. Especially when we work with a large dataset with various ...

How to Use COUNTIF Function Across Multiple Sheets in Excel

The COUNTIF function is a very useful function when it comes to counting the number of cells which obey a specified criterion in an Excel worksheet. ...

How to Use IF and COUNTIF Functions Together in Excel

While working on an Excel worksheet, you need to work with different functions. Sometimes, you need to combine the functions also to solve a problem. ...

How to Use COUNTIF Between Two Dates and Matching Criteria in Excel

The article will show you how to use Excel COUNTIF or COUNTIFS function between two dates and matching criteria. Basically, the COUNTF function ...

How to Use COUNTIF and COUNTA Functions Together in Excel

While working in Excel, we often need to count the number of cells irrespective of the data type of the cell contents based on some specific ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo