Count data with in date range

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.

Please Login or Register  to view this content.

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

Hi,

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

thx,

Joachim

www.jdrconsultancy.be

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

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?

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

Please Login or Register  to view this content.