Counting the Number of Cells in an Excel Range

Post author:Neale Blackwood
Post published:20/08/2024
Post category:Excel Blog Functions Tips & Tricks
Post comments:2 Comments

Excel has functions to count the number of rows and columns in a range. It doesn’t have a function to count the number of cells in a range. We can still perform the calculation with the COUNTA function.

(more…)

Excel Filtering for Blanks or Zeroes

Post author:Neale Blackwood
Post published:18/08/2017
Post category:Data Excel Blog
Post comments:0 Comments

If you want to filter by blanks across multiple columns the standard Filter feature can’t help you. You can use the Advanced Filter but that takes time to set up and most users don’t know how to use Advanced Filter. (more…)

End of content

No more pages to load