Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing #VALUE!
I don't think you need sumproduct in this case
=IF(A24=A23,G24,"") (put in the sheet names) in case you need sumproduct you can use a custom format like General;-General;; it will not show zero -- Regards, Peo Sjoblom (No private emails please) "Steved" wrote in message ... Thanks Bruno Yes I thought this may be the answer but was not to sure. "Bruno Campanini" wrote: "Steved" wrote in message ... 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)} CityPanmureDepots!$G$24 to be Numeric! Then you can have 0. You can't have any blank as a result from SUMPRODUCT(). Bruno |
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 |