On Sunday 10 July 2005 02:48 am, Horst Gerbig wrote: > Hi, > > I suppose you are looking for a formula like > > =(SUM(A1:E1))/(SUM(A2:E2)) > > Or did I misunderstand you? > >>On Saturday 09 July 2005 08:55 pm, EugenHotmail wrote: > >>>I have a question, actually 2 > >>>Some time back I downloaded a preview of OOo 2 and liked the skin. > >>>Now yesterday with my slow dial up I downloaded a beta and it looks like > >>>the former version. > >>>Where do I find the new skin, or has it been dropped? > >>>Second > >>>In calc, how do I do a simple calculation, like 5 divided by 2 equals > > > >2.5 > > > >>>(I mean in a formula) > >> > >>In Calc you would go to a cell and enter: > >> > >>=5/2 > >> > >>Or > >> > >>=(5/2) > >>and the result would be what is displayed in the cell. > > > >Thanks howard! > >I know this works fine with digits. But what if I sum(row A) and sum(Row > > B) and now want to divide re results lest say a/b ? > >
Another way to do it, using columns as an example, is to put your =SUM(A1:A15) in Cell A16, and =SUM(B1:B15) in Cell B16 [This means to add up all the numbers from B1 through B15] so you can see those results and then do something like =A16/B16 in the cell where you want to do the division. -- See Ya' Howard Coles Jr. John 3:16! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
