G
Guest
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(VLOOKUP("City",'1st
Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1)*IF(ISNA(VLOOKUP("Panmure",'1st
Week'!$A$1:$H$10000,6,0)),"",SUBSTITUTE(TEXT(VLOOKUP("Panmure",'1st
Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1)
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(VLOOKUP("City",'1st
Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1)*IF(ISNA(VLOOKUP("Panmure",'1st
Week'!$A$1:$H$10000,6,0)),"",SUBSTITUTE(TEXT(VLOOKUP("Panmure",'1st
Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1)