Does sumproduct formula work in Open office spreadsheet

[CD01]

I've got a formula on my laptop at home in excel 2007 will it work on my open office spreadsheet on my work laptop.

=SUMPRODUCT(--(TRANSAKSIES!DATUM<=KREDITEURE!$C$1),--(TRANSAKSIES!DATUM>KREDITEURE!$B$1),--(TRANSAKSIES!KREDITEURE=KREDITEURE!$A3),TRANSAKSIES!BEDRAG)

[Moo the Dog]

View this OpenOffice wiki regarding SUMPRODUCT... it will work, but the structure may have to be modified:

http://wiki.openoffice.org/wiki/Docu...ODUCT_function

Something like this may work:

Please Login or Register  to view this content.

- Moo