 |
 | 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 / Setup / April 2005sumif use
Hi, I want to use sumif in the following way : SUMIF(purchases!O18:purchases!O500,"=b21",purchases! Q18:purchases!Q500) and not : SUMIF(purchases!O18:purchases!O500,"=01960",purchases! Q18:purchases!Q500) in otherwords I want to use the value of the cell b21 to look up and not the typed in value ( 01960 ) can this be done ? thanks steve SUMIF(purchases!O18:purchases!O500,"="&B21,purchases!Q18:purchases!Q500)  SignatureRegards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy > Hi, > [quoted text clipped - 15 lines] > > steve Hi Andy, many thanks it works a treat regards steve >-----Original Message----- >SUMIF(purchases!O18:purchases!O500,"="&B21,purchases!Q18:purchases!Q500) [quoted text clipped - 20 lines] > >. Why not =SUMIF(purchases!O18:purchases!O500,B21,purchases!Q18:purchases!Q500) ? Regareds > Hi Andy, > [quoted text clipped - 31 lines] >> >>. As a pedagogical exercise??? The OP could see how to change the formula to look for greater than (or any other comparison operator). Just my guess. > Why not > =SUMIF(purchases!O18:purchases!O500,B21,purchases!Q18:purchases!Q500) [quoted text clipped - 43 lines] > >> > >>. 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.