 |
 | 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 / January 2008sumif criteria
The following expression works fine in Excel 2002 ver SP3: =SUMIF(Carlos!B14:B74,"<6",Carlos!F14:F74) When values in B are less than 6 the corresponding values in F are summed. However, I do not know how to write in the correct format when I wish to sum values in F for the B values of 6, 7, 8, and 9. Thanks in advance for any help. You could use: =SUMPRODUCT(--(Carlos!B14:B74>=6),--(Carlos!B14:B74<=9),Carlos!F14:F74) Tyro > The following expression works fine in Excel 2002 ver SP3: > [quoted text clipped - 5 lines] > > Thanks in advance for any help. WOW ! Great ! Thank you. I will give it a try. If you don't mind me asking, where could I learn the formats for these types of expressions ? Thanks again ! > You could use: > =SUMPRODUCT(--(Carlos!B14:B74>=6),--(Carlos!B14:B74<=9),Carlos!F14:F74) [quoted text clipped - 10 lines] >> >> Thanks in advance for any help. Among others http://xldynamic.com:80/source/xld.SUMPRODUCT.html Do a google for Excel sumproduct. > WOW ! Great ! Thank you. I will give it a try. > [quoted text clipped - 17 lines] >>> >>> Thanks in advance for any help. A simpler way is =SUMIF(Carlos!B14:B74,">=6",Carlos!F14:F74)-SUMIF(Carlos!B14:B74,">9",Carlos!F14:F74)  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > WOW ! Great ! Thank you. I will give it a try. > [quoted text clipped - 17 lines] >>> >>> Thanks in advance for any help. Thank you both for your help. I got it working ! I also appreciate the web site. >A simpler way is > [quoted text clipped - 21 lines] >>>> >>>> Thanks in advance for any help. Another one: =SUM(SUMIF(Carlos!B14:B74,{6,7,8,9},Carlos!F14:F74)) SignatureBiff Microsoft Excel MVP > The following expression works fine in Excel 2002 ver SP3: > [quoted text clipped - 5 lines] > > Thanks in advance for any help. |
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.