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
|