Hello From Steved

The Below gives me City but not Panmure. I am trying to add 2 times in
Column H.

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

Thankyou.


"Steved" wrote:

Hello From Steved

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.

As for an example The below adding 352:29+1092:32=1445:01, but the below
formula is returning 16045:49, yes I put * between the two formula to give an
idea as to what I am trying to acheive. Thanks

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