[libreoffice-users] Calc CountIf Alternative/Work Around

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: users+unsubscribe@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