Count data with in date range

[klis]

Hi guys,

I'm trying to count data within specific date ranges - Specific being per month.

And I guess I'm just being a retard, but it just doesn't seem to work - I keep getting #Value and #ref errors

In B I have the dates and in C I have the data which I would like to count.

=SUMPRODUCT(INDIRECT("DNV!$C$13:$C$1000"),"MH")*(INDIRECT("DNV!$B$13:$B$1000">=1/9/2011<=30/9/2011))

I'm using Indirect to prevent the cell numbers from changing as in the main sheet, rows are inserted on top.

I wondered if I should reverse the criteria (Date range followed by Data lookup) but that didn't work either

Cheers in advance,
Klis

[jdrConsultancy]

Hi,

can you provide me with a sample document so I can see exactly what you mean?

thx,

Joachim

www.jdrconsultancy.be

[klis]

Ok, I can't actually upload a full sheet, so its just a snippet. However, as a result, the (Indirect( has no relevance.

[klis]

Ultimately all I would like (perhaps ignore my example) is the best way to work out a count calculation that looks up a specific date range and counts the requested criteria?

[klis]

I tried this, but now im just more confused :D

=SUMPRODUCT(--(indirect("DNV!$B$13:&B$1000"<>""),--(Month("DNV!$B$13:$B$1000")=9)*(INDIRECT("DNV!$C$13:$C$1000"), "MH")))