Excel Functions Archives

How to Use CONCAT Function in Excel

Oct 17, 2023

In this article, we have talked about how to use the CONCAT function in Excel. We have demonstrated various examples of using the CONCAT function ...

How to Use VBA Array Function in Excel

Jul 24, 2023

The Array Function is a very useful tool in Excel to store data and limit the use of the variable, which is basically saving a lot of memory usage of ...

Excel SUMIF Function for Not Equal Criteria

Nov 1, 2023

In this article, we will know how to use Excel SUMIF not equal criteria. Excel's SUMIF function is a strong tool for computing sums based on ...

Excel SUMIF Function for Not Equal Criteria

Sum If Greater Than and Less Than Cell Value in Excel

Oct 31, 2023

In Excel, you may apply multiple conditions to sum values. From them, the greater than and less than condition is mostly used. You can use both ...

Sum If Greater Than and Less Than Cell Value in Excel

How to Use SUMIF to SUM Less Than 0 in Excel (3 Easy Ways)

Oct 31, 2023

In this article, we will illustrate how to use the Excel SUMIF function to sum values less than 0. Profit and loss are highly related to business. ...

How to Use SUMIF to SUM Less Than 0 in Excel (3 Easy Ways)

How to Use Excel SUMIF with Greater Than Criterion

Oct 31, 2023

In this modern world, life without Excel is kind of unimaginable. Almost in every working sector, Excel works as an essential tool. Numerous ...

How to Use Excel SUMIF with Greater Than Criterion

How to Use Excel SUMIF Function Based on Cell Color

Nov 1, 2023

Are you tired of manually sorting data in Excel to find and add up values based on cell color? Look no further than the Excel SUMIF function. This ...

How to Use Excel SUMIF Function Based on Cell Color

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

Nov 21, 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)

Oct 26, 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)

Oct 26, 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

Oct 31, 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)

Nov 1, 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)

Nov 1, 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)

Nov 1, 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)

Nov 1, 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 ...