Hi there,

I'm using the SUMPRODUCT forumla to count enties in a databse with specific cells and I've managed to get it nearly working. Here is my current formula which is not working (returns #N/A):

=SUMPRODUCT(--('HID Raw Data Look Up'!F:F>=C4)*--('HID Raw Data Look Up'!F:F<=C5)*--('HID Raw Data Look Up'!C:C="Devon South"))

The problem I seem to be having is that the Devon South criteria is the result of a vlookup forumla (I can't copy and paste values as I need cells to calculate automatically). When I tried it with raw text the same formula worked. Is there a way to get around this so that I can keep this column (C:C) as formula driven but my SUMPRODUCT formula sees it as a text value and counts it?

For information the first 2 criteria are a date ranges and on thier own without the 3rd criteria, work fine.

I hope this makes sense, any help would be greatly appreciated.