Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 04 Jan 2019 22:19:52 +0100Exclude strings in parentheses with SUMPRODUCThttps://ask.libreoffice.org/en/question/178284/exclude-strings-in-parentheses-with-sumproduct/Hello!
I have the following formula : =SUMPRODUCT(AA19:BX19<>"",AA19:BX19<>"X",AA19:BX19<>G19,AA19:BX19<>L19,AA19:BX19<>P19).
I need this formula to count how many cells contain none of the values (strings) "", "X" and none of the values (strings) of the cells G19, L19, and P19. I need to modify this formula in order to exclude all the strings (again in the same range AA19:BX19) that are included in parentheses, so they are not going to be counted. For example I need to exclude anything like (JOHN), (MARY), (TOM), (GEORGE). How can I do this? Thanks!
alex72grFri, 04 Jan 2019 22:19:52 +0100https://ask.libreoffice.org/en/question/178284/