Skip to main content

Posts

Showing posts from February, 2011

Excel Sum that calculates from the next row up

Excel Sum of from a cell to the RowAbove, or the next row above I got the idea and concept here: Three Ways to Reduce Errors In Your Excel SUM Formulas Essentially; what I wanted to do was prevent the Insert Row just above the total line to always include the row above. So after playing a bit I found the site above. So here is the process: In the workbook you want to have the sum click on any cell Depending on the version of Excel find where you name a range, for 2007 Formulas, Define Name A new name dialog box is displayed Make Name "RowAbove" Scope: Workbook Add a comment the next row up Delete the sheet name and enter in the row aboves address, in my case I clicked on =MySheet!$B$4, so I replace that with "=!B3" Then anywhere I want to add a sum or subtotal I just use sum(A3:RowAbove), then that will sum from A3 to the row above Now even if a insert row above on the formula it will add it the value to the sum.

A new site using FREE Google Sites

I believe that Google sites is one of the best kept secrets. Recently my Mom had asked me to put a site together for her to show here art to prospective buyers. Initially I just threw together a quick and dirty site to get her up and running, but afterwards she kept asking me to upload this pic and that pic, so I started looking around for open source Gallery products. After playing with a few, that look quote good, I found their setup tedious an requiring to many auxiliary downloads, like MySQL (it is now over 100MB to download, that is definitely one reason to go for SQL Express) After playing around a bit when I had time I thought, surely using Picasa and Google sites must be an option. 4 hours later I had a site up and running, nothing brilliant, but she can upload photos of new art when she wants, and can change anything she likes. The site does not work too well on a mobile device but otherwise it is fully functional. Her potential client just need to click on Gail Machanik

This guy is funny - Steve Williams

I saw this chap and would love to hear / see more. I had seen a lot of people on Michael McIntyre's roadshow but he is one that stood out. Here is a link the a YouTube clip of that show. YouTube - Michael McIntyre's Comedy Roadshow - Steve Williams : "Steve Williams"> His site looks good too Steve Williams Home Want to try get more.