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.

"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

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

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

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.

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

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