Adds City but not Panmure ( Combined Total )

[Guest]

Hello From Steved

My thinking is if I type {"City","Panmure"}, it would give me a combined
total but it is only giving me City, Can you please steer me in the right
direction.

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

Thankyou.

 

[Bob Phillips]

You know what they say about a little knowledge Steve <bg>

I think this is what you want

=SUMPRODUCT((A2:A20={"City","Pamure"})*(F2:F20/24))

and format it as time

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

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(VLOOKUP({"City","Panmure"},'1st
Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1)

 

[Guest]

Hello from Steved

The below formula adding 352:29+1092:32=1445:01, 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("Wiri",'1st
Week'!$A$1:$H$10000,6,0)),"",SUBSTITUTE(TEXT(VLOOKUP("Wiri",'1st
Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1)*IF(ISNA(VLOOKUP("Papakura",'1st
Week'!$A$1:$H$10000,6,0)),"",SUBSTITUTE(TEXT(VLOOKUP("Papakura",'1st
Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1)

 

[Bob Phillips]

Sorry, you have lost me completely mate. I am lost as to what City, Panmure,
Wiri, Papakura is all about, and what is where.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Sorry about the confusion

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.

As for an example The below formula adding 352:29+1092:32=1445:01, 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)

 

[Guest]

Please ignore I have posted another one

Thankyou.