Ive stumbled into one of those totally frustrating things that you cant see the reason for:
C65=countif(C3:C61, "Lt Blue") E65=countif(E3:E61, "Lt Blue") G65=sum(c65+e65) = 2 I have cleared all formatting. I have started from scratch. I opened another sheet and started. Im not typing the words in, Im copy and pasting into the cells and for the life of me I can not figure out why the C column shows no counted values. (I have many colors here so its not just Lt Blue. Its also Red, Green, White, etc.) -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted