Hi, I've got a calc spreadsheet, and I'm trying to sum data based on three different criteria (data to sum in column J, criteria in columns A, H & K. I'm trying to work out the syntax for using the sumproduct function to be able to do this, but I keep getting results of 0. Anyone have any ideas, or know if there is a calc function that does the same as SUMIFS in excel?? Thanks, Daniel -- View this message in context: http://nabble.documentfoundation.org/Libre-office-version-3-4-4-Calc-Using-excel-2007-formula-SUMIFS-tp4040417.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted