First time here? Check out the FAQ!

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

2 | No.2 Revision |

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`

?

3 | No.3 Revision |

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`

?

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.