Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing #VALUE!
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing #VALUE!
"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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing #VALUE!
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing #VALUE!
SUMPRODUCT is not an array formula.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "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)} Thankyou. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing #VALUE!
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 |
#6
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 |
#7
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 |