I'm wondering if version 2 OO Spreadsheet will have compatibility with Excel's SumProduct function, which lets you examine a table and sum items in a given column based on multiple criteria in one or more other columns.
For example, in the sheet "Expenses, you make a table: A B C Account Category Amount Office Paper $10.00 Office Stamps $30.00 Office Ink $20.00 Adver. Print $200.00 Adver. Web $3,000.00 Adver. Email $400.00 Office Ink $50.00 In some other sheet you put this formula in a cell: =SUMPRODUCT((Expenses!$A$2:$A$8="Office")*(Expenses!$C$2:$C98="Ink")*(Expenses!$I$3:$I$498)) The result will $70.00. This is an incredibly useful, easy to manage function. I have a pile of Excel spreadsheets that use it. So far, (ver. 1.1) OO can't deal with them. LBG __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]