| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing #VALUE!
Thankyou all
"Ron Rosenfeld" wrote: On Sun, 20 Nov 2005 14:01:01 -0800, Steved wrote: Hello from Steved The below is Showing #VALUE! What is required please to show a blank Cell. {=SUMPRODUCT(--(CityPanmureDepots!$A$24=$A$23),CityPanmureDepots! $G$24)} Thankyou. =IF(ISNUMBER(CityPanmureDepots!$G$24),SUMPRODUCT(--(CityPanmureDepots!$A$24=$A$23),CityPanmureDepots! $G$24),"") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns showing up as thin vertical lines | Excel Discussion (Misc queries) | |||
| Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
| Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
| formula in cell not showing result | Excel Worksheet Functions | |||
| Bar showing value for missing data | Charts and Charting in Excel | |||
Hybrid Mode
