Search, find & display
Solved/Closed
Related:
- Search, find & display
- How to search for words on websites - Guide
- Google search from usa - Guide
- Huawei display check code - Guide
- Yahoo search history - Guide
- Computer turns on but no display - Guide
4 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 16, 2016 at 11:13 AM
Nov 16, 2016 at 11:13 AM
noob, Good afternoon.
Supposing your example:
Sheet1 --> B2:I6
Sheet2 --> B3:C8
Try to use:
Sheet2
B3 --> =SUMPRODUCT((Sheet1!$C$2:$I$6=C3)*(Sheet1!$B$2:$B$6))
Copy it down.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Supposing your example:
Sheet1 --> B2:I6
Sheet2 --> B3:C8
Try to use:
Sheet2
B3 --> =SUMPRODUCT((Sheet1!$C$2:$I$6=C3)*(Sheet1!$B$2:$B$6))
Copy it down.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
learningenquirer
Posts
1
Registration date
Thursday November 17, 2016
Status
Member
Last seen
November 17, 2016
Nov 17, 2016 at 03:00 AM
Nov 17, 2016 at 03:00 AM
(Previously noob)
Thanks for that. I don't think that is what i was after. I don't think i explained it very well.
Second attempt.
Sheet 2 Cell B142 is the cell i am putting my formula in. I am hoping to drag down the formula in column B.
Sheet 1 is my week # reference.
I want the formula to use the date in Sheet 2 Cell C142 (in this case 16/06/2016) to search my list in Sheet 1 and find the date (16 Jun 16 in Cell F110) and the corresponding week. Answering the formula with the week # (25 from Cell A110).
Would love to find a way to make this happen.
Thanks in advance. :)
Thanks for that. I don't think that is what i was after. I don't think i explained it very well.
Second attempt.
Sheet 2 Cell B142 is the cell i am putting my formula in. I am hoping to drag down the formula in column B.
Sheet 1 is my week # reference.
I want the formula to use the date in Sheet 2 Cell C142 (in this case 16/06/2016) to search my list in Sheet 1 and find the date (16 Jun 16 in Cell F110) and the corresponding week. Answering the formula with the week # (25 from Cell A110).
Would love to find a way to make this happen.
Thanks in advance. :)
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 17, 2016 at 08:33 AM
Nov 17, 2016 at 08:33 AM
learningenquirer, Good morning.
"...Thanks for that. I don't think that is what i was after..."
The formula that was suggested to you is exactly what you need.
"...I don't think i explained it very well..."
Your need is a simple process to understand.
Since you have sent us only one image of part of your spreadsheet, I will adapt the formula by changing the intervals for what we can see.
You should adjust your formula to the reality of your data.
Sheet2 --> B142
=SUMPRODUCT((Sheet1!$B$2:$H$111=C142) * (Sheet1!$A$2:$A$111))
If you prefer, save your worksheet to some free website, www.sendspace.com and place the download link here.
It's faster and easier for us to help you.
"...Thanks for that. I don't think that is what i was after..."
The formula that was suggested to you is exactly what you need.
"...I don't think i explained it very well..."
Your need is a simple process to understand.
Since you have sent us only one image of part of your spreadsheet, I will adapt the formula by changing the intervals for what we can see.
You should adjust your formula to the reality of your data.
Sheet2 --> B142
=SUMPRODUCT((Sheet1!$B$2:$H$111=C142) * (Sheet1!$A$2:$A$111))
If you prefer, save your worksheet to some free website, www.sendspace.com and place the download link here.
It's faster and easier for us to help you.
