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
|