Showing #VALUE!
SUMPRODUCT is not an array formula.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"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)}
Thankyou.
|