Need value as per given criteria
Solved/Closed
Sanam Khan
-
Jun 20, 2015 at 06:56 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 23, 2015 at 09:56 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 23, 2015 at 09:56 PM
Related:
- Need value as per given criteria
- Transfer data from one excel worksheet to another automatically based on criteria ✓ - Excel Forum
- IF statements with dates and criteria ✓ - Excel Forum
- How to copy cell value from one table to another table with Criteria ✓ - Excel Forum
- Conditional formatting on multiple criteria ✓ - Excel Forum
- Vba code to copy data from one sheet to another based on criteria ✓ - Excel Forum
4 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 21, 2015 at 12:25 PM
Jun 21, 2015 at 12:25 PM
Sanam Khan, good morning.
Try to use it, like this one:
Is this what you want.
I hope it helps.
Try to use it, like this one:
Is this what you want.
I hope it helps.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 21, 2015 at 01:38 PM
Jun 21, 2015 at 01:38 PM
Your file need a password to access ???
Save your file at a free site like www.speedyshare.com and put the link to download here
Save your file at a free site like www.speedyshare.com and put the link to download here
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 22, 2015 at 01:31 PM
Jun 22, 2015 at 01:31 PM
Sanam Khan, Good afternoon.
Your table of values has a very unusual way to write.
Try to use:
M4 --> =SUMPRODUCT(($E$5:$E$20>=L4)*($F$5:$F$20<=L4)*($G$5:$G$20))
Copy it down.
Is this what you want?
I hope it helps.
Your table of values has a very unusual way to write.
Try to use:
M4 --> =SUMPRODUCT(($E$5:$E$20>=L4)*($F$5:$F$20<=L4)*($G$5:$G$20))
Copy it down.
Is this what you want?
I hope it helps.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 23, 2015 at 09:56 PM
Jun 23, 2015 at 09:56 PM
Sanam Khan, Good evening.
I fell glad for your feed back.
Have a nice day.
I fell glad for your feed back.
Have a nice day.
Jun 21, 2015 at 12:45 PM
Please see/download the file from the link below. I need to take out points in yellow highlighted field.
https://drive.google.com/file/d/0BxfIO6gperXld1Izd0NBMzMxX1U/view