All...

I'm looking to use the SUMPRODUCT to present back the a percentage of
transactions that are tied to a specific user... the challenge is that the
user can be selected from a dropdown list and populated in a specific named
cell address the name for the cell is RptEmployee... ideally the manager can
select any unique user from the dropdown list and generate the report based
on the users specific data
here is the formular which is pulling all of the data and making the
specific selection on the (RptEmployee=RptEmployee) segment... any help is
greatly appreciated in advance-

=SUMPRODUCT((CaseAcceptance="N")*(CaseMonth="July" )*
(RptEmployee=RptEmployee)*(Counter))/COUNTIF(CaseMonth,"=July"))
--
Joe Mac