On 09/09/2017 05:18 PM, Brian Barker wrote: > Yup. Your syntax is almost right, but not quite. You need: > COUNTIF(Slant.B38:Slant.B1038;">"&IQ_Slant.B44)
Thanks. That worked. > You can no doubt see that COUNTIF() expects an inequality to be > expressed as a text string. So ">1234" will work, but not ">A1", since > that "A1" will not be seen as a cell reference. If you need to > incorporate a cell reference, you need to concatenate the ">" sign with > the value in the cell, which will automatically be converted to text > because of the context of the reference. This looks like one of those basic things that I should have known, but somehow or other missed. :( Now wondering how many other things I've missed/skipped over, without realizing it. jonathon -- To unsubscribe e-mail to: [email protected] 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
