Your solution did not provide the proper answer and selections should have been 
removed. Here is the proper formula solution for all the parameters which 
assumes self adjusting defined named ranges for columns a:e

=SUMPRODUCT((cola=I3)*((colb=$M$2)+(colb=$K$2))*((colc=$M$3)+(colc=$N$3)+(colc=$O$3))*((cold=$M$4)+(cold=$N$4)+(cold=$O$4))*cole)
 

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Karan Singh 
Sent: Friday, September 07, 2012 12:12 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Please Help

Hi Jeet, 

I think you're not able to explain your problem. As all expert said at least  
you should explain your queries in Subject & then in your workbook. Anyways I'v 
done something (with recording), hope you need this. I'm not an expert I'm an 
excel learner :)
Pfa.

Rgds

Karan Singh






On Thu, Sep 6, 2012 at 7:49 PM, Rajan_Verma <rajanverma1...@gmail.com> wrote:

  Same as don





  Regards

  Rajan verma

  +91 7838100659 [IM-Gtalk]



  From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of dguillett1
  Sent: 06 September 2012 6:08


  To: excel-macros@googlegroups.com
  Subject: Re: $$Excel-Macros$$ Please Help


  I  did NOT look at your attachment because you did not provide a meaningful 
subject line in your post and you did not explain your problem in the body of 
the email. I hope you explained, with examples, in the file. But, I didn’t look.



  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com



  From: jeet singh 

  Sent: Wednesday, September 05, 2012 11:58 PM

  To: excel-macros@googlegroups.com 

  Subject: $$Excel-Macros$$ Please Help





  Dear All, 



  plz find the attachment and help....



  Regards

  Jeet


  -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   
  FORUM RULES (1120+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  6) Jobs posting is not allowed.
   
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
  --- 
  You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
   
   

  -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   
  FORUM RULES (1120+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  6) Jobs posting is not allowed.
   
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
  --- 
  You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
   
   

  -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   
  FORUM RULES (1120+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  6) Jobs posting is not allowed.
   
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
  --- 
  You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
   
   


-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


Reply via email to