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.
CityPanmureDepots!$G$24 to be Numeric!
Then you can have 0.
You can't have any blank as a result from SUMPRODUCT().