# Revision history [back]

Are the contents or results in your column I numbers or strings?

-1- Are you sure you enabled Tools > Options > LibreOffice Calc > Enable regular expressions in formulae? Without that NO formula can actually interpret with RegEx. (The parentheses are necessary if you want to define an alternative.)

-2- Always use YYYY-MM-DD if Dates shall also be comparable if given as texts. I am not sure if the otherwise necessary conversions are reliebale.

-3- Did you consider to use SUMPRODUCT() for your purpose? It might relief you of some ticklish issues occurrung with the "Criteria" toy. (Automatic conversions again.)

Are the contents or results in your column I numbers or strings?
-1- Are you sure you enabled Tools > Options > LibreOffice Calc > Enable regular expressions in formulae? Without that NO formula can actually interpret with RegEx. (The parentheses are necessary if you want to define an alternative.)
-5- In a as-if range like $I14:$I: How should Calc decide if you mean $I$1 or $I$1048576 by the single $I ? May I suggest first of all that you read https://ask.libreoffice.org/en/question/131311/ ? Can you upload an example demonstrating your problem? Are the contents or results in your column I numbers or strings? -1- Are you sure you enabled Tools > Options > LibreOffice Calc > Enable regular expressions in formulae? Without that NO formula can actually interpret RegEx. (The parentheses are necessary if you want to define an alternative.) -2- Always use YYYY-MM-DD if Dates shall also be comparable if given as texts. I am not sure if the otherwise necessary conversions are reliebale. -3- Did you consider to use SUMPRODUCT() for your purpose? It might relief you of some ticklish issues occurrung with the "Criteria" toy. (Automatic conversions again.) -4- What shall the SUM() in your forula be goog for? -5- In a an as-if range like $I14:$I: How should Calc decide if you mean $I$1 or$I$1048576 by the single $I ?