by Ilker | Mar 6, 2019 | Excel Formulas
The Excel COUNTA function is a statistics formula that returns the number of cells in a range containing numbers, text, logical values, error values, and empty text (“”). In this guide, we’re going to show you how to use the Excel COUNTA function and also...
by Ilker | Jul 13, 2018 | Excel Tips & Tricks
To count by week number is a bit different than by month. Instead of finding the start and end dates of the date range, we focus on exact week number using the WEEKNUM function. Syntax =COUNTIFS( range of week number helper column, current week number) Steps Add a...
by Ilker | Jun 12, 2018 | Excel Tips & Tricks
Excel intersect operation is handled by the space character (” “). You can intersect multiple rages by space in range supporting formulas. This article shows how to COUNT intersecting ranges with COUNT function and Excel intersect operator. Syntax...
by Ilker | Apr 2, 2018 | Excel Tips & Tricks
A quick and easy way to count between dates is by using the COUNTIFS formula. Create formula-based filters, find your sales figures, or organize your tables in no time. Syntax =COUNTIFS(date range, >=minimum date, date range, <=minimum range) Steps Type...
