Thread: COUNTIFS function ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eng Teng Eng Teng is offline
external usenet poster
  
Posts: 6
Default COUNTIFS function ?
A
1 10
2 20
3 30
4 40

=COUNTIFS(A1:A4,"20",A1:A4,"<40")
ANSWER = 1

In excel 2003 COUNTIFS function not supported so
How do I write in excel 2003 the formula?


Regards,
Tee

Reply With QuoteReply With Quote