 |
 | 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 / July 2006Cell values as criteria for SUMIF and other functions
Hi, I have just changed jobs and am now working on XP instead of office 2000. I used to be able to write a formula such as: =SUMIF(A2:A10,<D2,B2:B10) I can't seem to be able to reference a cell for a criterion when the operator is anything other than "=". Can somebody point me in the right direction. Thanks & Regards, Will > Hi, > [quoted text clipped - 10 lines] > > Will Hi Will The correct syntax is: =SUMIF(A2:A10,"<"&D2,B2:B10)  SignatureBest regards Leo Heuser Followup to newsgroup only please. Thanks guys, its always easy when you know how. Cheers, Will > Thanks guys, its always easy when you know how. > > Cheers, > > Will You're welcome, Will :-) Leo Heuser Hi Will, try this: =SUMIF(A2:A10,"<"&D2,B2:B10) Hope this helps. Pete > Hi, > [quoted text clipped - 10 lines] > > Will
|
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.