| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! ERROR
Why am I getting a #VALUE! in a blank cell with the following formula:
=SUMPRODUCT((G32*4+H32*2)*(IF($A32="","",SUMPRODUC T((Sheet1!$A$2:$A$26=$A32)*(Sheet1!$G$2:$G$26))))) -- George |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE! ERROR
Because you're trying to multiply a range by a blank. You can't multiply
blanks; they are valueless. Better to do something like this: =IF(ISBLANK($A32),"",[your SUMPRODUCT formula]) Dave -- Brevity is the soul of wit. "George" wrote: Why am I getting a #VALUE! in a blank cell with the following formula: =SUMPRODUCT((G32*4+H32*2)*(IF($A32="","",SUMPRODUC T((Sheet1!$A$2:$A$26=$A32)*(Sheet1!$G$2:$G$26))))) -- George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom error bars not working | Charts and Charting in Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
| error "module not found" | Excel Discussion (Misc queries) | |||
| #REF error | Excel Worksheet Functions | |||
Linear Mode
