On Monday, February 18, 2013 18:01:16, Jack Chastain wrote: > On Mon, Feb 18, 2013 at 5:38 PM, Matthias Johnson < ... > You are correct in that I can't read an ods with an android. Never > > > tried as I typically save in office formats since many people wouldn't > > know what an ods is. > > I know what odious is, but not ods. Unless the latter is the former.
.ods = OpenDocument Spreadsheet. What's nice about the OpenDocument formats is that they are a fully documented format _and_ implemented how they're documented. If you do just a bit of research into the OpenDocument format vs Microsoft's "Office Open XML" formats, you'll see why this is an important distinction. > As for if your install is broken maybe? I can press save as and get a > > > full list of document formats on mint and windows installs. Can't help > > with the formula question though. > > Not sure anyone can help ;-) - what I am trying to do is get an average of > the data in a column above the row the data is on. The average bit is easy: > "-=AVERAGE($D$3:D3)" - That will look odd on the first line, but when you > drag it down - say 13 rows, it becomes "=AVERAGE($D$3:D13)" - which is > exactly right for row 13 - but if the data in rows 4-13 isn't yet present > (this is a mileage comparator/calculator, so until time passes, it won't > be), I want to really say "If there is information provided in cell D2, > then give me the average, otherwise give me 0" I've got an idea of how to deal with this. AVG = SUM / COUNT, so... instead of using the AVERAGE function, use SUM(range) / COUNT(range) -- because the COUNT function skips over empty cells. There's also a function to count the number of empty cells, if you need it. -- Chris -- Chris Knadle [email protected] _______________________________________________ Mid-Hudson Valley Linux Users Group http://mhvlug.org http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug Upcoming Meetings (6pm - 8pm) Vassar College Feb 6 - Raspberry Pi Mar 6 - 10th Anniversary Meeting - Linux where you least expect it Apr 3 - Typography: Physical Art to Digital Art
