All:
In the spreadsheet I'm working on, I'm trying to find the number of
items that are more than 6 standard deviations from the norm.
Standard deviation formula is StDev(Slant.B38:Slant.Slant.B1038))
That formula works.
The obvious solution, as expressed in the formula
COUNTIF(Slant.B38:Slant.B1038,>IQ_Slant.B44) does not work.
Error # 510: Missing Variable.
Using quotation marks for the criteria to search by (">IQ_Slant.B44")
does not work.
Is there a way to count the number of cells whose value is greater than
the variable, when the variable is the value found in a specific cell?
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
