 |
 | 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 / General Excel Questions / May 2008sumif within a range
I have used the sumif function to calculate an answer if the data is less than or greater than a certain value, however want to calculte an answer if the data is within a range. Eg. I know how to calculate the following; If value in A1 > than 5 then sum value of A2. I want to calculate the following but don't know how; If value in A1 is between 2 and 5 sum value of A2 One way: =If(And(A1>=2,A1<=5),A2,"")  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I have used the sumif function to calculate an answer if the data is less > than or greater than a certain value, however want to calculte an answer if > the data is within a range. Eg. I know how to calculate the following; If > value in A1 > than 5 then sum value of A2. I want to calculate the following > but don't know how; If value in A1 is between 2 and 5 sum value of A2 |
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.