An alternative way to formulae is to use Data/Data pilot/Activate... (perhaps an approximate translation, in french Données/ Pilote de données/activer) This allows you simple conditional calculations like the example you give. Marie
> 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]
