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