Thread: Showing #VALUE!
View Single Post
  #7   Report Post  
Old November 22nd 05, 10:08 PM posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default 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