| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Excel say this formula contains an error?
It seems as if you've all given up on me. :( No problem. I finally found the formula to calculate my worksheet's W-L statistics properly, without recalculating games after current results are entered. The SumProduct function suggested by Harlan Grove was the key. Thanks a bunch Harlan. I paid a visit to 'xlDynamic.com' (http://www.xldynamic.com/source/xld.SUMPRODUCT.html) which has a fantastic article about the SumProduct function. From there I adapted one of their formulas to my suit my needs, resulting in the following formula: =SUMPRODUCT((Game_number<=C53)*(SU_record="W"))&"-"&SUMPRODUCT((Game_number<=C53)*(SU_record="L" )) -- HuskerBronco ------------------------------------------------------------------------ HuskerBronco's Profile: http://www.excelforum.com/member.php...fo&userid=4803 View this thread: http://www.excelforum.com/showthread...hreadid=559396 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL ERROR - series formula is too long | Excel Worksheet Functions | |||
| Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
| Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
| Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Threaded Mode
