Use the sumif function. =SUMIF(coderange;"S";moneyrange) will give a total of S.
"Randy W. Carrels" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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! Randy C. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
