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
- Vba code to copy data from one sheet to another based on criteria ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Macro to insert row in excel based on criteria ✓ - Excel Forum
- Vba code to move rows to another sheet based on criteria ✓ - Excel Forum
- How to sum values based on criteria in another column in excel ✓ - 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