Hi :) I don't quite understand what you are trying to do. Do columns A & B both already contain data? So are you trying to look-up all the values in B that have an A in column A and then add those numbers up? Regards from Tom :) ________________________________ From: macroC <macrochelys@gmail.com> To: users@global.libreoffice.org Sent: Fri, 2 September, 2011 12:05:54 Subject: [libreoffice-users] Calc Formula Help So I have two columns of data, column A which has a single character (A, G, or T) and column B which has a number. I am trying to determine the minimum value in B that corresponds to an "A" in column A. This is the forumla I came up with after looking at tutorials and reading the documentation: =MIN(IF(A1:A7="A",B1:B7)) But this simple gives a #VALUE error. Can anyone help me figure out what is wrong with the formula? Thanks. -- View this message in context: http://nabble.documentfoundation.org/Calc-Formula-Help-tp3303917p3303917.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 -- 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