This blog and video will demonstrate two alternative ways, using Excel SUMIFS function, to sum a range ignoring blank, text or error cells.
Why can’t I kill the Excel External Links?
There are many reasons why we need to break source, Excel external links; including the four less obvious sources of external links.
Average an Excel range – ignoring blank, text or error cells & largest & smallest values
This tutorial will present one way to return an average of an Excel range, whilst ignoring blanks, text, errors, as well as excluding the largest…
Largest value in Excel range (advanced approach) – ignore blanks, texts or errors
This video will present a solution for returning the largest value across a data range, which contains text, errors and blanks. In normal circumstances we…
Deleting rows based on error values across sheets
Hi. Today’s video will show you how to delete rows of data based on cell errors across worksheets. As we can see, some of the…
How to change from exponential to number format in Excel – Advanced
Welcome, this is a follow-on video to an earlier presentation with solving exponential number format problems with numerical cells, especially when dealing with Excel csv…
How to change from exponential to number format in Excel
This article will show one approach to correct the exponential number format referencing issue in a cell, especially when dealing with csv files. Sometimes, as…
Remove x characters from right of cell using Excel VBA
Goal: To present a VBA macro alternative to an earlier video on extracting characters from the right of each cell in a selection. This video…