Resources
How to SUM values across sheets
To sum range of cells in the same worksheet is one of the basic concepts of Excel. What about summing values across sheets? In this article we will explain how to sum values across sheets. Syntax =SUM(first sheet : second sheet ! reference) Steps Start...
How to count values if date is less than by using COUNTIF function
Using the versatile COUNTIF and COUNTIFS functions, see how you can count cells up to a certain date. How to count values if date is less than by using COUNTIF function article shows an essential tip for creating YTD (year-to-date) reports. Syntax...
How to convert D/M/YYYY date to M/D/YYYY or vice versa
Data formats differ by locations in the world. Once you understand the syntax of dates you can easily convert them from one locale to the other. In this article, we will cover the most standard date conversion in Excel: converting D/M/YYYY to M/D/YYYY....
How to count values if date is greater than by using COUNTIF function
Using the versatile COUNTIF and COUNTIFS functions, see how you can count values if date is greater than from a certain date. An essential tip for creating YTD (year-to-date) reports. Syntax =COUNTIFS(date range, >minimum date) =COUNTIF(date range,...
How to calculate running count
This article shows how to calculate running count by using COUNTIF and COUNTIFS functions. The running totals help you to track number of value occurrences in your data. Syntax =COUNTIF(expanding range of lookup values, lookup value again) Steps Add a new...
How to get nth match with VLOOKUP
This article shows you how to get the nth match with VLOOKUP formula. Unfortunately, Excel doesn't have a built-in function to find any value beyond the first match. Syntax Unique lookup value: =lookup value & COUNTIF(expanding range of lookup values,...
How to Excel SUM Formula Filtered Values in Datatables
The regular Excel SUM formula calculates the total of all values in a range, including those hidden by filters or the "Hide" feature. While this default behavior is suitable for many scenarios, it can become problematic when creating interactive spreadsheets that...
How to Count the Number of Columns in Excel
In the realm of data management and analysis, Microsoft Excel stands out as a powerful tool due to its array of functions that facilitate efficient data manipulation. One such function is the ability to determine the total number of columns within a given range. While...
How to Get The Number of Rows Containing Data in Your Table
Excel offers numerous built-in features to streamline data analysis. For instance, you can manually count the number of entries in your spreadsheet by selecting the relevant rows, and the count will be displayed in the bottom right corner. However, this process can...