On Sat January 28 2006 05:20, + Randy W. Carrels wrote: > [ MODERATED ] ******************** > I have created a spreadsheet in OO 2.0.1 in which I have figures in column > E and F and letters in column G. There are a few other columns of figures > and the example is simplified > > example: $6.00 $3.00 S > $27.00 $12.50 T > $7.26 $3.63 S > > What I would like to do is filter the 78 rows that have S and have the sum > total of F displayed (corresponding to the S, T, etc.) in a seperate cell > as well as for sum for T's, etc. > > Example: S= $$6.63 > T= $12.50 > > The formulas I have been continually come up with display the error $NAME? > and I can't seem to figure out where the problem can be corrected or how to > "NAME" the range in the formula!
As you are not subscribed you may not have seen that: On Sat January 28 2006 10:28, Paul wrote: > I would suggest you could do something similar using the function > 'sumif' ... Have a read of the documentation and see what you come up > with. Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
