counting function

[nespa]

I typed the formula and it errored:

=sumproduct(('Test Issues'!D51000>=DATEVALUE("9/1/2004"))*( 'Tes
Issues'!D51000<DATEVALUE("10/1/2004"))*('Tes
Issues'!F5:1000="Closed"))


Here is the scenerio:

D51000 each cell contains a date in the format mm/day/year

F5:F1000 each cell contains a word- either Closed or Open

I am tying to calculate the amount of Closed Issues for each Month.

Thanks

 

[Frank Kabel]

Hi
small typoe. try:
=sumproduct(('Test Issues'!D51000>=DATEVALUE("9/1/2004"))*( 'Test
Issues'!D51000<DATEVALUE("10/1/2004"))*('Test
Issues'!F5:F1000="Closed"))