ExcelBanter - COUNTIFS

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COUNTIFS (https://www.excelbanter.com/excel-discussion-misc-queries/254761-countifs.html)

AlexW

COUNTIFS

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

Jacob Skaria

COUNTIFS

Use SUMPRODUCT() as below

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

--
Jacob

"AlexW" wrote:

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

AlexW

COUNTIFS

Jacob
Thank you very much, it works perfectly.
AlexW

"Jacob Skaria" wrote:

Use SUMPRODUCT() as below

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

--
Jacob

"AlexW" wrote:

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

All times are GMT +1. The time now is 03:25 PM.