Need value as per given criteria
Solved/Closed
Sanam Khan
-
20 Jun 2015 à 18:56
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 23 Jun 2015 à 21:56
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 23 Jun 2015 à 21:56
Related:
- Need value as per given criteria
- Conditional formatting on multiple criteria ✓ - Excel Forum
- How Sum the Column value in Excel via VBA based on criteria? ✓ - Excel Forum
- Two criteria to check if a date in Excel ✓ - Excel Forum
- Looking up and adding the values fixing different criteria - Excel Forum
- Transferdata from 1 sheet to other sheets criteria - Excel Forum
4 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
21 Jun 2015 à 12:25
21 Jun 2015 à 12:25
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
21 Jun 2015 à 13:38
21 Jun 2015 à 13:38
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
22 Jun 2015 à 13:31
22 Jun 2015 à 13:31
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
23 Jun 2015 à 21:56
23 Jun 2015 à 21:56
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.
21 Jun 2015 à 12:45
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