=SUMPRODUCT(--(Sheet2!$A$2:$A$300=2006),--(Sheet2!$B$2:$B$300=7),--(Sheet2!$D$2:$D$300="mama"),Sheet2!$E$2:$E$300)

Adjust to suit


"ECLynn" wrote:

I have 2 seperate sheets. I want to pull the accuracy rates (Acc%1 and Acc%2)
from sheet #2 to sheet #1- it needs to reference by month and year. How can I
do this? Help!

Sheet 1

A B C D E
F
Year Month TSR Name Acc % 1 Acc%2%

2 2006 7 SMG Smith, George
3 2006 7 STR Rayan, Steve
4 2006 7 HVJ Johnson, Howard

Sheet 2
A B C D
E F
Year Month1 EE# TSR Acc % 1 Acc % 2
1 2006 7 32958 Smith, George 17.9% 74.3%
2 2006 7 32558 Rayan, Steve 5.9% 98.1%
3 2006 7 13538 Johnson, Howard 88.0% 90.5%


Thanks!
--
Erin