Thread: Showing #VALUE!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default 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.