Hello from Steved

In a Worksheet called 1st Week in Col "A" I have "City" and "Panmure", and
in Col "B" to Col "H" I have Data.

I would like the formula to find City in Col "A" ( 1st Week ) then From the
second Col "B" ( 1st Week ) capture the data from that cell, then find
Panmure in Col "A" ( 1st Week ) then From the second Col "B" ( 1st Week )
capture the data from that cell, and now paste the Captured Data in worksheet
Called Summary.

Thankyou

I wasn't quite sure if this is what you want but this will sum all data in
column B where column A has "City" or "Panmure".

Insert in cell in Summary.

=SUMPRODUCT(('1st Week'!A2:A5={"City","Panmure"})*('1st Week'!B2:B5))

"Steved" wrote:

> Hello from Steved
>
> In a Worksheet called 1st Week in Col "A" I have "City" and "Panmure", and
> in Col "B" to Col "H" I have Data.
>
> I would like the formula to find City in Col "A" ( 1st Week ) then From the
> second Col "B" ( 1st Week ) capture the data from that cell, then find
> Panmure in Col "A" ( 1st Week ) then From the second Col "B" ( 1st Week )
> capture the data from that cell, and now paste the Captured Data in worksheet
> Called Summary.
>
> Thankyou

Hello from Steved

The below is giving me a #VALUE!

=SUMPRODUCT(('1st Week'!A1:A2000={"City","Panmure"})*('1st Week'!B1:B2000))

Any idea's please as to what might be.

Thankyou.



"Toppers" wrote:

> I wasn't quite sure if this is what you want but this will sum all data in
> column B where column A has "City" or "Panmure".
>
> Insert in cell in Summary.
>
> =SUMPRODUCT(('1st Week'!A2:A5={"City","Panmure"})*('1st Week'!B2:B5))
>
> "Steved" wrote:
>
> > Hello from Steved
> >
> > In a Worksheet called 1st Week in Col "A" I have "City" and "Panmure", and
> > in Col "B" to Col "H" I have Data.
> >
> > I would like the formula to find City in Col "A" ( 1st Week ) then From the
> > second Col "B" ( 1st Week ) capture the data from that cell, then find
> > Panmure in Col "A" ( 1st Week ) then From the second Col "B" ( 1st Week )
> > capture the data from that cell, and now paste the Captured Data in worksheet
> > Called Summary.
> >
> > Thankyou

Toppers' formula works for me. The most likely cause of the #Value error with
your formula is having text in column B. There need only be a single cell
containing text in B1:B2000.

Regards,
Greg

"Steved" wrote:

> Hello from Steved
>
> The below is giving me a #VALUE!
>
> =SUMPRODUCT(('1st Week'!A1:A2000={"City","Panmure"})*('1st Week'!B1:B2000))
>
> Any idea's please as to what might be.
>
> Thankyou.
>
>
>
> "Toppers" wrote:
>
> > I wasn't quite sure if this is what you want but this will sum all data in
> > column B where column A has "City" or "Panmure".
> >
> > Insert in cell in Summary.
> >
> > =SUMPRODUCT(('1st Week'!A2:A5={"City","Panmure"})*('1st Week'!B2:B5))
> >
> > "Steved" wrote:
> >
> > > Hello from Steved
> > >
> > > In a Worksheet called 1st Week in Col "A" I have "City" and "Panmure", and
> > > in Col "B" to Col "H" I have Data.
> > >
> > > I would like the formula to find City in Col "A" ( 1st Week ) then From the
> > > second Col "B" ( 1st Week ) capture the data from that cell, then find
> > > Panmure in Col "A" ( 1st Week ) then From the second Col "B" ( 1st Week )
> > > capture the data from that cell, and now paste the Captured Data in worksheet
> > > Called Summary.
> > >
> > > Thankyou

Thanks Greg

"Greg Wilson" wrote:

> Toppers' formula works for me. The most likely cause of the #Value error with
> your formula is having text in column B. There need only be a single cell
> containing text in B1:B2000.
>
> Regards,
> Greg
>
> "Steved" wrote:
>
> > Hello from Steved
> >
> > The below is giving me a #VALUE!
> >
> > =SUMPRODUCT(('1st Week'!A1:A2000={"City","Panmure"})*('1st Week'!B1:B2000))
> >
> > Any idea's please as to what might be.
> >
> > Thankyou.
> >
> >
> >
> > "Toppers" wrote:
> >
> > > I wasn't quite sure if this is what you want but this will sum all data in
> > > column B where column A has "City" or "Panmure".
> > >
> > > Insert in cell in Summary.
> > >
> > > =SUMPRODUCT(('1st Week'!A2:A5={"City","Panmure"})*('1st Week'!B2:B5))
> > >
> > > "Steved" wrote:
> > >
> > > > Hello from Steved
> > > >
> > > > In a Worksheet called 1st Week in Col "A" I have "City" and "Panmure", and
> > > > in Col "B" to Col "H" I have Data.
> > > >
> > > > I would like the formula to find City in Col "A" ( 1st Week ) then From the
> > > > second Col "B" ( 1st Week ) capture the data from that cell, then find
> > > > Panmure in Col "A" ( 1st Week ) then From the second Col "B" ( 1st Week )
> > > > capture the data from that cell, and now paste the Captured Data in worksheet
> > > > Called Summary.
> > > >
> > > > Thankyou