=COUNTBLANK(A1)+COUNTBLANK(B3) Met vriendelijke groeten, Salutations distinguées, Kind Regards,
DRIES FEYS CORPORATE SERVICES • Specialist Software Developer On 5 July 2013 09:42, minhsien0330 <[email protected]> wrote: > Dear all: > If I just want count blank cell in A1, B1, C1 and D1, tell Calc > "=COUNTBLANK(A1:D1)" is OK > > But I just want count blank cell in A1 and B3, so I wrote: > "=COUNTBLANK(A1,B3)" > > and I got a message "Err 504". > > Do you know how to count blank cell in A1 and B3 only? > > Thank you so much. > > Best Regards, > Minhsien0330 > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- **** DISCLAIMER **** http://www.tvh.com/newen2/emaildisclaimer/default.html "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- To unsubscribe e-mail to: [email protected] 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
