=SUMIF(INDIRECT("'Recap Report2'!$C$7:$C"&$K$2),145,INDIRECT("'Recap
Report2'!$D$7:$D"&$K$2))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"parteegolfer"
wrote in message
news:parteegolfer.26u7sm_1145997603.5979@excelforu m-nospam.com...
This did not work, still getting error
--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile:
http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=536132