Bug 28420 - countif shows as #VALUE!
Summary: countif shows as #VALUE!
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: 2.0-FINAL
Hardware: PC Solaris
: P3 normal with 2 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Blocks: 34973
  Show dependency tree
Reported: 2004-04-15 21:51 UTC by Chris Cheshire
Modified: 2008-05-05 13:54 UTC (History)
0 users

zip file containing spreadhseet with countif error example (12.13 KB, application/octet-stream)
2004-04-15 21:55 UTC, Chris Cheshire

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cheshire 2004-04-15 21:51:41 UTC
On the "summary" sheet cells C6:C9 and E6:E9 have COUNTIF formulas referring to 
other pages in the spreadsheet, but do not calculate in excel until you double 
click the formula, then hit enter.
Comment 1 Chris Cheshire 2004-04-15 21:55:25 UTC
Created attachment 11252 [details]
zip file containing spreadhseet with countif error example
Comment 2 Josh Micich 2008-05-05 13:54:39 UTC
Retested OK in 3.1-beta1

This was probably fixed due to bug 44675 (var-args param count issues)