Adding 2 cells together and paste into 1 cell
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 |
Adding 2 cells together and paste into 1 cell
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 |
Adding 2 cells together and paste into 1 cell
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 |
Adding 2 cells together and paste into 1 cell
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 |
Adding 2 cells together and paste into 1 cell
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 |
All times are GMT +1. The time now is 04:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com