| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sumif formula with multiple critera | Excel Worksheet Functions | |||
| Getting Excel whilst using the sumif formula to search for part of a word | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| formula (perhaps sumif?) | Excel Discussion (Misc queries) | |||
| Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
Hybrid Mode
