Method 1 - Make a 3D Table with a 3D Dataset We have the following dummy dataset containing 3 tables. The tables are interconnected through the 3 variables: product_company, year, and region.…
The COUNTIF function is used extensively to count values based on criteria. Using wildcards in the criteria makes the formula more dynamic. Unfortunately, sometimes it may seem that the Excel COUNTIF formula…
You can use the Functions Translator add-in by Microsoft to translate the language of formulas in Excel. Step 1 - Inserting the Functions Translator Add-in to Translate Language in Excel Go to…
The following VLOOKUP function returned 0 although the matching result is an empty cell. Step 1 - Using the IF Function to Stop the VLOOKUP from Returning 0 Use the following…
Reason 1 - COUNTA Function Is Not Working for Blanks Returned by Formulas We have used the IF function in the range D5:D12 to extract numbers greater than 70 and return empty…
Google Sheets and Microsoft Excel are both powerful spreadsheet applications, but they differ in several aspects. In this article, we will explore the various aspects of Google Sheets and Excel and discuss…
Conditional Formatting is a very popular feature in Excel that lets you format your dataset when applied criteria are met. But it may become a tiresome job if you need to apply…
We will use the following dataset to highlight the methods to copy every nth row in Excel. Method 1 - Use OFFSET and ROW Functions Let's copy every 3rd row starting from…
Dataset Overview Assume you have the following Excel dataset containing store-wise sales. Step 1 - Enable “Update Automatic Links at Open” for a Word Document Open the Word document containing the sales…
In this article, we will show you how to convert CSV files to Excel in several ways. Comma-separated values or CSV is a very useful and extensively used file format. It is…
Steps Select the entire dataset (B4:C13). Then go to Insert >> Insert Scatter (X, Y) or Bubble Chart >> Scatter as shown below. The following chart will be created. Click the chart…
Method 1 – Using the DATE Function The below dataset has days, months, and years in separate columns. We need to concatenate them to create proper dates. Steps: Enter the following formula…
A variable width column chart portrays data in a more convenient way as the columns correspond to the values in the dataset, unlike a simple column chart. Unfortunately, up until now, there…
The Cash Flow Waterfall Chart in Excel is a great feature that allows you to present the cash flows in a smart way. Creating a Waterfall chart has become easier for users…
What Is Lag Time? Lag Time or Time Lag is a delay between two successive tasks, whereas the later task should start as soon as the earlier task ends. Suppose a project…
![[Fixed] COUNTIF Function with Wildcard Not Working in Excel](https://www.exceldemy.com/wp-content/uploads/2022/11/excel-countif-wildcard-not-working-6-300x280.png?v=1697441968)
![[Fixed] Excel COUNTA Function Not Working](https://www.exceldemy.com/wp-content/uploads/2022/10/excel-counta-not-working-2-300x267.png?v=1697435880)
