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 multiple workbooks).
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 will be contacting each of the winners by email and they have 10 days to respond and claim their prize; at which point a new random winner will be chosen. So here are the winners:
- 1st Prize – sherrygo@xxxxxx.xxx - 10 Hours free consulting from XLAutomation
- 2nd Prize – willbost@xxxxxx.xxx - Copy of Office XP 2007 Standard
- 3rd Prize – jonesrtr@xxxxxx.xxx – 2Gb iPod Shuffle from ExcelConsultant.net
- 4th Prize – Blogger Template – Themelib.com - $50 Cash through Paypal
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 Hints helpful and welcome.
A special thanks again to our contest sponsors, XLAutomation & ExcelConsultant.net. Please take an moment to check out their site and services, they both do great work.
With all the success of this contest, Excel Hints will definitely be holding more contests in the future to encourage participation with the site.
- John
Only 1 Week Left: $1400 of Prizes
THIS CONTEST CONCLUDED 11/30/2008. Thanks to everyone for entering.
Don’t worry… There’s still time to enter for chances to win some of the $1400 in prizes (including Excel Consulting, Office 2007, an iPod Shuffle and Cash). Sign up for our email feed or write a post about the contest. It’s that easy. Click Here for full contest details.
The contest has been a great success so far. Here’s some details of the participation:
- Over 300 subscribers are currently signed up (a 200% increase since the start of the contest; there were 107 the day before we started).
- 22 Posts about the contest on other sites
Again I’d like to thank everyone that has participated so far. I’d also like to thank our contest sponsers XLAutomation & ExcelConsultant.net. Check out their sites, they offer some great services.
What Version Of Excel Do You Use?
We just closed our first poll on Excel Hints after receiving over 100 votes. Thanks to everyone who participated. The results were pretty much as expected. We asked users of the site which version of Excel they were currently using.
I expected the results be lean more towards Excel 2003 still, since it seemed to me that many businesses out there have not felt the need to upgrade to 2007 yet. I think some are still nervous about learning the new interface that Office 2007 came out with. But the poll shows the results are pretty close between Excel 2003 & Excel 2007 for readers of Excel Hints. Below is a chart of the results of the poll.
Loading ...