Help with SUMIF formula Please

[parteegolfer]

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

[Don Guillett]

try without the " "

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"parteegolfer" <parteegolfer.26u6ep_1145995811.2024@excelforum-nospam.com>
wrote in message
news:parteegolfer.26u6ep_1145995811.2024@excelforum-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
>

[parteegolfer]

This did not work, still getting error

[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" <parteegolfer.26u6ep_1145995811.2024@excelforum-nospam.com>
wrote in message
news:parteegolfer.26u6ep_1145995811.2024@excelforum-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
>

[Bob Phillips]

=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" <parteegolfer.26u7sm_1145997603.5979@excelforum-nospam.com>
wrote in message
news:parteegolfer.26u7sm_1145997603.5979@excelforum-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
>