Thanks very much. It works like a charm. You're terrific.

"pomalley" wrote:

I'm trying to add another criteria that will look at the cell in column Z to
see if the record has been tagged for use in report(s). Column Z can contain
one or more tags. Multiple tags would indicate that the record is to be
included in more than one report.

Cells in Column Z could look as follows; the letter/report names indicate in
which report(s) the record should be included.

AB, CDE, EFG, GHI, IJK, KLMN
AB, CDE, GHI, KLMN
AB, CDE, EFG, GHI, IJK, KLMN
EFG, GHI, IJK, KLMN
AB
AB, KLMN

I want to retrieve the records that meet the criteria to be added to report
AB, CDE, etc. I'm using the following query and want to add the report
criteria to this:

=SUMPRODUCT((MONTH('[Wkly Rpt 2005.xls]Data'!$A$2:$A$500)=MONTH(S$1))*
((LEFT('[Wkly Rpt 2005.xls]Data'!$B$2:$B$500,3)="STP"))*
((LEFT('[Wkly Rpt 2005.xls]Data'!$T$2:$T$500,1)=$K$2)))