<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - COUNTIF function doesn't return values when Criteria is set to a cell" href="https://bugs.documentfoundation.org/show_bug.cgi?id=119980#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - COUNTIF function doesn't return values when Criteria is set to a cell" href="https://bugs.documentfoundation.org/show_bug.cgi?id=119980">bug 119980</a> from <a class="email" href="mailto:christopher.d.tan@gmail.com" title="christopher.d.tan@gmail.com">christopher.d.tan@gmail.com</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=145022" name="attach_145022" title="Spreadsheet with COUNTIF function">attachment 145022</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=145022&action=edit" title="Spreadsheet with COUNTIF function">[details]</a> Spreadsheet with COUNTIF function Cells E3 =COUNTIF($B$3:$B$32,D11) I forgot to add that B3:B32 uses the LEFT function.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>