COUNTIFS

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
 
J

Jacob Skaria

Use SUMPRODUCT() as below

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

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

Excel Need Countifs Formula Help 0
Counting Cells with Multiple Range Criteria (Excel 2003) 7
Finding lowest count in any column 12
COUNTIF Cells in Range? 4
Multi-demensional frequency distribution 4
Countifs and date comparison 3
COUNTIF Function on filtered data 2
How do I do a conditional CountIf function 1

Top