You might try reading this over. Its pretty old but been updated over time.
https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=2762 -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Mon, Apr 7, 2025 at 8:25 AM Martin Byttebier <[email protected]> wrote: > > 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: [email protected] > 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: [email protected] 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
