At 15:39 28/07/2015 +0900, Howard Barr wrote:
I have calc sheet with 4 columns A1 is Date, B1 is Vendor, C1 is
Item, D1 is Cost. I would like to extract the accumulated
expenditure of an item and display it in F1. There are over 1,000 items.
If I understand you correctly,
=SUMIF(C2:C2000;"Item
Hi,
I have calc sheet with 4 columns A1 is Date, B1 is Vendor, C1 is Item,
D1 is Cost.
I would like to extract the accumulated expenditure of an item and
display it in F1.
There are over 1,000 items.
Help greatly appreciated.
Hbarr
--
To unsubscribe e-mail to: users+unsubscr...@global.libr
Am 26.07.2015 um 23:17 schrieb Stephen R. Blevins:
>
> My usual practice to update the numerical data on my spreadsheets is to
> copy a "template" row (properly formatted) and use Paste Special (with
> Shift Cells set to "Down") to insert it into a formula-ranged matrix
> (such as SUM, or AVG, etc
Hi,
Can anyone help me with this?
I still haven't found a way.
I should be able to translate most Basic code, so don't let my use of C++ stop
you from suggesting ideas :)
Thomas wrote:
> I'm trying to get the current page number of where the document is shown
> (scrolled to), not where the cur
Hi,
Regina wrote:
> It seems the commands have changed. In LO 4.4 and LO 5.1 (on Windows7)
> recording gives .uno:ScrollToPrevious and .uno:ScrollToNext for down, both
> with empty property array. Perhaps you try those.
Thank you very much, that works as expected :)
Regards,
Thomas
--
To un
On Sat, 2015-07-18 at 18:25 -0700, James E Lang wrote:
> The big discussion of Linux over the past 24+ hours has me wondering: What
> operating environment(s) do other members of this list use at home and at
> work? What factors influence the choice?
> To set the tone, here are my answers:
openS
On Fri, 2015-07-24 at 21:03 -0400, charles meyer wrote:
> It's gratifying seeing so many posts about who's using Linux, which
> resources and other software.
> I haven't found a good Linux forum so I appreciate those using Linux
> on this forum as you share your workouts and solutions.
> Evince (pd