counting function

[nespa]

Need help in counting the text "Closed" in the date range from d5:d100
and the word Closed is in the range f5:d1000.

I am using the following function but I am creating the functio
incorrectly

COUNTIF(SUM((('Test Issues'!D51000)>=VALUE("9/1/2004"))*(( 'Tes
Issues'!D51000)<VALUE("10/11/04"))):SUM('Tes
Issues'!F5:1000),”CLOSED”)

Thanks for your hel

 

[duane]

I THINK this is what you want - your question was not that clear

sumproduct(('Test Issues'!D51000>=A1)*( 'Tes
Issues'!D51000<B1)*('Test Issues'!F5:1000=CLOSED))

assuming you put the min and max dates in A1 and B

 

[Frank Kabel]

Hi duane
small typo -> missing apostrophes

=sumproduct(('Test Issues'!D51000>=A1)*('Test
Issues'!D51000<B1)*('Test Issues'!F5:1000="CLOSED"))