Thread: COUNTIFS function not supported in Excel 2003
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default COUNTIFS function not supported in Excel 2003
Maybe

=SUMPRODUCT(('Raw Data'!E1:E1000<=4)*('Raw Data'!L1:L1000=1))

Mike

" 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

Reply With QuoteReply With Quote