 |
 | 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 / November 2006help with adding... SUMIF formula?
I'm looking for a formula that will do the following: A1-A12 contains numbers. and I want a formula that will add up whatever number of cell I enter in B1 example: B1, I enter 6 the formula will add from A1 to A6 9 will add up A1-A9, etc... sumif formula maybe? if anyone can help I'd appreciate it. thanks! One way: =IF(B1>0,SUM(OFFSET(A1,0,0,B1,1)),"") > I'm looking for a formula that will do the following: > [quoted text clipped - 8 lines] > > thanks! =IF(B1=0,"",SUM(A1:INDIRECT("A"&B1))) Vaya con Dios, Chuck, CABGx3 > One way: > [quoted text clipped - 12 lines] > > > > thanks! brilliant!! thanks you guys! ended up using ths one.. =SUM(A1:INDEX(A1:A12,B1)) thanks again! Good choice, non-volatile <G>  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > brilliant!! > [quoted text clipped - 5 lines] > > thanks again! Hi! Try this: =SUM(A1:INDEX(A1:A12,B1)) Note: if B1 is empty the entire range will be summed. Biff > I'm looking for a formula that will do the following: > [quoted text clipped - 8 lines] > > thanks! =SUM(A1:INDEX(A1:A12,B1)) SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > I'm looking for a formula that will do the following: > [quoted text clipped - 8 lines] > > thanks!
|
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.