Help with SUMIF formula Please

P

parteegolfer

Can someone help me with this formula, I keep getting a formula contain
error message however I do not see what the error is.

=SUMIF('Recap Report2'!$C$7:$C&$K$2),"$145.00",('Reca
Report2'!$D$7:$D"&$K$2)

$k$2=400 in worksheet "Data" which is the worksheet that I am puttin
this calculation.

Thanks,
ParteeGolfe
 
T

Tim C

Try:

=SUMIF(INDIRECT("'Recap Report2'!$C$7:$C$"&$K$2),"$145.00",INDIRECT("'Recap
Report2'!$D$7:$D$"&$K$2))

You probably need to also change "$145.00" to 145 (without double quotes).

Tim C

"parteegolfer" <[email protected]>
wrote in message
news:p[email protected]...
 
Top