Hi,
Please help me with the following problem.
how can I get the column value with multiple criteria of rows matching.
PD PN Q Jan Feb Mar
A B 1 44 33 55
C V 3 34 32 5
if I have 4 textboxes specifying A, B, 1, and Jan respectively, I would like to get a value 44.
Thank you.
Which version of Excel are you using? Is it still the OLD Excel 2007?
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
i am using excel 2007.
OK. Explain how you arrive at the result of 44, please.
Yes, please can you please elaborate your query in detail.
i want to get the value of the month with the input of product id, product name, quantity and the month.
Yes, but I cannot see where 44 comes from. Explain how you manually calculated 44.
no. the 44 is just the example.
if you refer to the pic, I want to the value 2 to be displayed in a textbox, if I input 1 for product ID abbd for product name, 34 for quantity and Feb for month.
This is not about calculation. i just want to get the value with the multiple criteria.
sorry for confusing.
Capture.JPG
Try this:
=SUMPRODUCT(($A$2:$A$16=M2)*($B$2:$B$16=M3)*($C$2:$C$16=M4)*($E$1:$K$1=M5),$E$2:$K$16)
AliGW on MS365 Insider (Windows) 32 bit
abbd Feb
Sheet: Sheet1
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
this works good. thank you.
but how can i input using textboxes instead typing in M2, M3, M4, and M5.
Sorry - I did not spot that you want VBA for this. That's not my thing - someone else may be able to help.
Be patient, please. Your duplicate thread has been closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks