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