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 cellDepending on the version of Excel find where you name a range, for 2007 Formulas, Define NameA new name dialog box is displayedMake Name "RowAbove"Scope: WorkbookAdd a comment the next row upDelete 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 Gal…