COUNTIFS

  • Thread starter Thread starter AlexW
  • Start date Start date
A

AlexW

I am using Excel 2003 which it seems does not accommodate COUNTIFS.

I need to look up criteria in column A (say a date like "Nov-09" for
example) and from column D count the number of matching items that are less
than or fall between two numbers.
AlexW
 
Use SUMPRODUCT() as below

=SUMPRODUCT((TEXT(A1:A100,"mmm-yy")="Nov-09")*(B1:B100>=5)
*(B1:B100<=10))
 
Back
Top