Hi all, i have an issue with a SUMPRODUCT formula i'm using, i use the formula to count instances of data validated text within a named range (multiple columns), the forumla works perfect, i even use it to check two data validated cells for dates and count between the dates, the problem i have now is that i need to be able to count instances of text as once per 7 day date range for each column, below is the formula and attached is my sample workbook.
=C$2-SUMPRODUCT(((INDIRECT("'"&$B3&"'!cnproc")="TRN")+(INDIRECT("'"&$B3&"'!cnpro c")="SIC")+(INDIRECT("'"&$B3&"'!cnproc")="LD")+(INDIRECT("'"&$B3&"'!cnproc" )="SAF")+(INDIRECT("'"&$B3&"'!cnproc")="UN")+(INDIRECT("'"&$B3&"'!cnproc")= "ABO"))*(dlist>=$A$3)*(dlist<=$A$5))