 |
 | 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 / June 2007sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
How can I sum values in my third column by specifying conditions in my first two? e.g. Column A has values "Jon", "Max", "Mary", "Tom" Column B has values "A" and "B". Column C has values for each. I need to sum C values where column A shows "Jon" and column B shows "B". I've tried =sumif(AND(A1:A10, "Jon"),(B1:B10, "B"), C1:C10) with no luck. the usual sumif should have the format =sumif(range to be assessed, Criteria, range to be summed) Try this: =SUMPRODUCT(--(A$1:A$10="Jon"),--(B$1:B$10="B"),C$1:C$10) HTH, Paul > How can I sum values in my third column by specifying conditions in my > first [quoted text clipped - 8 lines] > the usual sumif should have the format =sumif(range to be assessed, > Criteria, range to be summed) =SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10="B"),C1:C10)  SignatureRegards, Peo Sjoblom > How can I sum values in my third column by specifying conditions in my > first [quoted text clipped - 8 lines] > the usual sumif should have the format =sumif(range to be assessed, > Criteria, range to be summed) =SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10 SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > How can I sum values in my third column by specifying conditions in my > first [quoted text clipped - 8 lines] > the usual sumif should have the format =sumif(range to be assessed, > Criteria, range to be summed) very useful! what is the -- function for?? > =SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10 > [quoted text clipped - 10 lines] > > the usual sumif should have the format =sumif(range to be assessed, > > Criteria, range to be summed) See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation. SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > very useful! > what is the -- function for?? [quoted text clipped - 15 lines] >> > the usual sumif should have the format =sumif(range to be assessed, >> > Criteria, range to be summed) I hope that you noticed I missed a trailing bracket =SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10) SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > very useful! > what is the -- function for?? [quoted text clipped - 15 lines] >> > the usual sumif should have the format =sumif(range to be assessed, >> > Criteria, range to be summed) I saw that, but Excel would have corrected it. >I hope that you noticed I missed a trailing bracket > [quoted text clipped - 18 lines] >>> > the usual sumif should have the format =sumif(range to be assessed, >>> > Criteria, range to be summed) got it! this is a really good function, and thanks for pointing me towards that information website, can see it coming in handy. I thought my excel skills were fairly good, but this is described as a basic function! Thanks all Harry > I saw that, but Excel would have corrected it. > [quoted text clipped - 20 lines] > >>> > the usual sumif should have the format =sumif(range to be assessed, > >>> > Criteria, range to be summed) It is basic in its basic form, but what you see there is stretching it well beyond the basic in many instances, SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > got it! > this is a really good function, and thanks for pointing me towards that [quoted text clipped - 33 lines] >> >>> > the usual sumif should have the format =sumif(range to be assessed, >> >>> > Criteria, range to be summed) |
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.