Thread: Showing #VALUE!
View Single Post
  #3   Report Post  
Old November 20th 05, 11:33 PM posted to microsoft.public.excel.worksheet.functions
Posts: n/a
Default 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().