ExcelBanter - COUNTIFS function not supported in Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - COUNTIFS function not supported in Excel 2003 (https://www.excelbanter.com/excel-programming/412292-countifs-function-not-supported-excel-2003-a.html)

[email protected]

COUNTIFS function not supported in Excel 2003

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

[email protected]

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

Mike H

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

All times are GMT +1. The time now is 02:52 AM.