COUNTIFS function not supported in Excel 2003

  • Thread starter Thread starter engteng
  • Start date Start date
E

engteng

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
 
Hi
Try COUNTIF. There is no COUNTIFS function.
regards
Paul
 
Maybe

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

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIFS function ? 2
Excel Need Countifs Formula Help 0
VBA Countif across sheets? 5
COUNTIF calculations & Two-way Lookup 2
Excel Count If Formula Question 1
COUNTIF function help please 8
SUMPRODUCT question 4
CountIF = function not defined ??? 6

Back
Top