Hello Bob from Steved

I should have my instructions a little clearer.

I am adding information from sheet called "1st Week" and it is laid out into
seven days, it is put in a summary Sheet Called "City-Panmure Combined". So
my question is that if I take either City or Panmure it works as it should (
Singular ), how do I get it to add both City and Panmure. Thanks

=IF(ISNA(VLOOKUP({"City","Panmure"},'1st
Week'!$A$1:$H$10000,6,0)),"",SUBSTITUTE(TEXT(VLOOK UP({"City","Panmure"},'1st
Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1)

Thankyou.