On Tue, Feb 19, 2013 at 11:00 AM, Wesley Peterson < [email protected]> wrote:
> Jack, > > I use the following in the spreadsheet I keep my Checking Acct info in. > The following cell formula is replicated in my column J which I use for a > "Cover" amount: > *=IF(ISBLANK($B3),"",IF($D3=$D2,J2,0)+$E3)* > > I may have just fat-fingered a blank reply - so if one shows up here, apologies. This worked. I must have been missing a field before. What I ended up with is this: =IF(N(G8),SUM($G$3:G8)/COUNT($G$3:G8),"") N() returns whether the result of a cell is a number - if it is a formula (which G8 is) then a "normal" test doesn't work. That could have been some part of what I was doing wrong initially.So - If (Cell) is a number, return the average of all numeric fields above it otherwise store a null. Very cool. This has simplified my sheet quite nicely - and now if I can just find a way to edit it on my phone in .ods format, that would be cool. For now though, using /xls and both DropBox and Google Drive is probably sufficient. Thanks for the amazing help! JC -- Eschew obfuscation and pompous prolixity. Light a man a fire, he is warm for the night. Light a man afire, he is warm for the rest of his life.
_______________________________________________ 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
