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. |
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 |
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 |
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. |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com