Sum Values in a Range While Ignoring #N/A
Excel provides an easy way to sum a range of cells based on a given criteria. There are many ways this can be used but the example we are going to look at today is summing a range while ignoring #N/A’s in the same range. Without ignoring #N/A, the result of the sum will be [...]
Summing Across Multiple Sheets
You might have come across an instance where you want to use a function against multiple sheets in a workbook. Excel provides an easy way to calculate aggregate functions across a range of sheets. In the examples below, you will see how this can be performed against any range of sheets and sheet names (or even [...]
Excel Hints Contest Winners
The Excel Hints Contest had 346 entries – a great success. Thanks to everyone who participated and joined the Excel Hints community as well as our sponsors of the contest. There will definitely be more contests to come soon. Winners So let’s get to it. The winners were drawn at random using Excel. I [...]
Excel Hints Contest Has Concluded
As of 12:00pm EST, the first Excel Hints contest is now history. I will be announcing the winners and contacting them by email tonight (12/1/08). I’d like to thank everyone who participated by either subscribing to Excel Hints or writing a post about the contest. Hopefully you continue to find the posts here at Excel [...]
