 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006MULTIPLE CRITERIA RETURNING SUM OF RESULTS
I need to create a formula that will search through multiple columns for different criteria and then give the sum of another column based upon the search results. I tried using SUMIF, but it will only search through one set of criteria. I need it to search for multiple criteria. =SUMPRODUCT(--(rng1=value1),--(rng2="value2"),rng3) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > I need to create a formula that will search through multiple columns > for different criteria and then give the sum of another column based > upon the search results. I tried using SUMIF, but it will only search > through one set of criteria. I need it to search for multiple criteria. look into sumproduct =sumproduct(--($A$1:$A$500="Something",--($C$1$:$C$500="Something else")) make sure that the ranges you're searching through are of equal length. > I need to create a formula that will search through multiple columns > for different criteria and then give the sum of another column based > upon the search results. I tried using SUMIF, but it will only search > through one set of criteria. I need it to search for multiple criteria. What I need to is search Column A for a certain number. Once it finds all of that number then I need it to search Column E for another number. Then I need to get the total of Column C and then return the total to sheet 1 Cell A4. The formula you gave me worked, but it gave me a total of 0, instead of what it should have been. > look into sumproduct > [quoted text clipped - 6 lines] > > upon the search results. I tried using SUMIF, but it will only search > > through one set of criteria. I need it to search for multiple criteria. Then you didn't do it correctly (oh, and MDubbelboer missed a bracket) What did you use? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > What I need to is search Column A for a certain number. Once it finds > all of that number then I need it to search Column E for another [quoted text clipped - 12 lines] > > > upon the search results. I tried using SUMIF, but it will only search > > > through one set of criteria. I need it to search for multiple criteria. It's working now. I forgot to add the dashes. Thanks for your help. Tom > Then you didn't do it correctly (oh, and MDubbelboer missed a bracket) > [quoted text clipped - 25 lines] > > > > through one set of criteria. I need it to search for multiple > criteria. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.