[libreoffice-users] function value not being counted

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+unsubscribe@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