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
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 |
#5
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 |
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 |