On Thu, 10 Apr 2025 16:02:07 +0300 wodsfort <wodsfort@gmail.com> wrote: Wodsfort, why do you keep posting other people's messages with no new content?
Hello, I'm looking for a method to count the number of cells in a row that have a specific background color. I tried using =COUNTIF(G2:G360; #fff9c4), but it returns a #NAME? error. Then I tried =COUNTIF(G2:G360;"#fff9c4"), but it returns 0 — which is incorrect, since there are at least 50 cells with that background color. Obviously I'm missing something here — what's the right way to count cells with a specific background color?" TIA, Martin -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
-- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy