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]
