COUNTIFS function not supported in Excel 2003

's Computer Specifications

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

's Computer Specifications

Hi
Try COUNTIF. There is no COUNTIFS function.
regards
Paul
On Jun 9, 9:51*am, engt...@gmail.com 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

's Computer Specifications

Maybe

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

Mike

"(E-Mail Removed)" 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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert COUNTIFS function from 2007 to something in 2003 version	cbrannlayt	Microsoft Excel Misc	2	2nd Apr 2010 07:56 PM
Countifs function equivalent for Excel 2002 (XP)	Task Database Nightmare	Microsoft Excel Worksheet Functions	1	5th Jan 2010 07:04 PM
Excel 2007 countifs function problem	rcindyj01	Microsoft Excel Misc	2	29th Apr 2009 05:34 PM
Need function that will work in Excel 2003 like "Countifs" in 2007	RD	Microsoft Excel Worksheet Functions	3	1st Aug 2008 04:35 PM
translating countifs function to Excel 2003	ridgeback	Microsoft Excel Worksheet Functions	4	29th Apr 2008 10:18 PM