Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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 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.)

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 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.)

-4- What shall the SUM() in your forula be goog for?

-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 ?