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
