 |
 | 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 / New Users / October 2006sum if questions
Hi, I am having a memory block ! I need to sum costs in colum C, if column A = x and column B = Y. n When using sumif i appear to count all costs in column C not just the ones required.. any suggestiong where i'm going wrong ?? You can only use one condition with SUMIF. Either use SUMPRODUCT or SUM(IF(...)) entered as an array formula. Hope this helps. Pete > Hi, I am having a memory block ! > I need to sum costs in colum C, if column A = x and column B = Y. > n > When using sumif i appear to count all costs in column C not just the ones > required.. any suggestiong where i'm going wrong ?? =sumproduct(--(a1:a100="x"),--(b1:b100="y"),c1:c100) Adjust the ranges to match--but you can't use whole columns. =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail here: http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html > Hi, I am having a memory block ! > I need to sum costs in colum C, if column A = x and column B = Y. > n > When using sumif i appear to count all costs in column C not just the ones > required.. any suggestiong where i'm going wrong ??  SignatureDave Peterson
|
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.