View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default COUNTIFS function not supported in Excel 2003

Hi
Try COUNTIF. There is no COUNTIFS function.
regards
Paul
On Jun 9, 9:51*am, wrote:
Excel 2003 not support COUNTIFS function so How do I convert the
following formula in order to run on Excel 2007 ?

COUNTIFS('Raw Data'!$E:$E,"<=4",'Raw Data'!$I:$I,"1")

Regards,
Tee