Excel Functions Archives

How to Sum If Cell Contains Number in Excel (6 Examples)

May 22, 2023

Sometimes, we need to sum if a cell contains a number in Excel. We need to do this very often in data analysis and financial modeling. Sometimes the ...

How to Sum If Cell Contains Number in Excel (6 Examples)

Use of PERMUTATIONA Function in Excel (4 Simple Examples)

May 21, 2023

In this article, we will explore how to use the PERMUTATIONA Function in Excel to generate phone numbers, pin codes, license plate numbers, and even ...

Use of PERMUTATIONA Function in Excel (4 Simple Examples)

How to Use EVEN Function in Excel (5 Examples)

May 22, 2023

The EVEN function in Excel is a tool that can round up a number to the nearest even integer. It takes one argument, which is the number you want to ...

How to Use EVEN Function in Excel (5 Examples)

How to Sum If Cell Contains Number and Text in Excel

May 14, 2023

It is an informative article that provides solutions to a common problem encountered by Microsoft Excel users. This article discusses the challenge ...

How to Sum If Cell Contains Number and Text in Excel

How to Use Excel SUMIF with Blank Cells (3 Easy Methods)

May 17, 2023

This article illustrates how to use the SUMIF function to sum up values corresponding to blank or empty cells in Excel. Even though blank cells are ...

How to Use Excel SUMIF with Blank Cells (3 Easy Methods)

[Fixed!] Excel SUMIF with Wildcard Not Working (4 Solutions)

May 14, 2023

This article will discuss 4 possible solutions for Excel SUMIF not working with a wildcard. The SUMIF function often fails to recognize wildcard ...

[Fixed!] Excel SUMIF with Wildcard Not Working (4 Solutions)

Excel SUMIFS with Not Equal to Text Criteria (4 Examples)

May 11, 2023

In this article, we are going to discuss how to use the Excel SUMIFS function with Not Equal to Text criteria. Excel users often need to sum specific ...

Excel SUMIFS with Not Equal to Text Criteria (4 Examples)

Excel SUMIF Not Working (9 Possible Cases with Solutions)

May 11, 2023

With the help of Excel's SUMIF function, users can sum a range of numbers in accordance with specific criteria. However, there are times when the ...

Excel SUMIF Not Working (9 Possible Cases with Solutions)

How to Use SUMIF Function to Sum Not Blank Cells in Excel

May 11, 2023

Summing is one of the most performed operations in Excel. In Excel, there are multiple functions that you can use to sum values. Among these, the ...

How to Use SUMIF Function to Sum Not Blank Cells in Excel

How to Use DSTDEVP Function in Excel (2 Suitable Examples)

May 7, 2023

Are you looking for an Excel function that will return the standard deviation of the entire population and also match the given criteria? In this ...

How to Use DSTDEVP Function in Excel (2 Suitable Examples)

How to Use Excel SUMIF to Sum Values Greater Than 0

May 17, 2023

When working with large datasets in Excel, it is often necessary to sum values that meet a certain condition. One useful function for this purpose is ...

How to Use Excel SUMIF to Sum Values Greater Than 0

How to Use Excel DMAX Function (2 Easy Examples)

Jan 31, 2023

Excel is a powerful software as it has predefined functions and numerous features. These functions make the excel experience smoother and more ...

How to Use Excel DMAX Function (2 Easy Examples)

How to Use NPER Function in Excel (3 Relevant Examples)

Jan 24, 2023

Financial analysts frequently want to know the duration of repayment time while making a business deal. Therefore, if you are a financial analyst, ...

How to Use NPER Function in Excel (3 Relevant Examples)

How to Use DPRODUCT Function in Excel (6 Practical Examples)

Jan 22, 2023

While working in Excel, we often need to use various Database Functions. The DPRODUCT function is one of the most widely used database functions in ...

How to Use DPRODUCT Function in Excel (6 Practical Examples)

How to Use NOMINAL Function in Excel

Jan 24, 2023

Microsoft Excel is a handy software. We use Excel functions for our education, business, and financial analyses. Moreover, in light of the effective ...