 |
 | 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 / December 2007sumif help
I have a simple sumif formula which I can't get to sum. My current formula is =SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x in it; if it does I want to add the values in cells F3 and G3. Now all this formula does is check for the x in M3 and puts the F3 value in the cell. It doesn't add F3 and G3. Jim One way: =(M3="x")*(F3+G3)  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- >I have a simple sumif formula which I can't get to sum. My current formula >is [quoted text clipped - 7 lines] > > Jim Thanks that worked! > One way: > [quoted text clipped - 11 lines] > > > > Jim Appreciate the feed-back. SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- Thanks that worked! "RagDyer" wrote: > One way: > [quoted text clipped - 13 lines] > > > > Jim More straightforward: =IF(M3="x",SUM(F3:G3),0) > I have a simple sumif formula which I can't get to sum. My current formula is > =SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x [quoted text clipped - 3 lines] > > Jim |
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.