Try:
=SUMIF(INDIRECT("'Recap Report2'!$C$7:$C$"&$K$2),"$145.00",INDIRECT("'Reca p
Report2'!$D$7:$D$"&$K$2))
You probably need to also change "$145.00" to 145 (without double quotes).
Tim C
"parteegolfer"
wrote in message
news:parteegolfer.26u6ep_1145995811.2024@excelforu m-nospam.com...
Can someone help me with this formula, I keep getting a formula contains
error message however I do not see what the error is.
=SUMIF('Recap Report2'!$C$7:$C&$K$2),"$145.00",('Recap
Report2'!$D$7:$D"&$K$2)
$k$2=400 in worksheet "Data" which is the worksheet that I am putting
this calculation.
Thanks,
ParteeGolfer
--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile:
http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=536132