Help with SUMIF formula Please
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 |
Help with SUMIF formula Please
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 |
Help with SUMIF formula Please
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 |
Help with SUMIF formula Please
=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 |
All times are GMT +1. The time now is 02:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com