 |
 | 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 / June 2007Keeping a Running total
A1 Credits, B1 Debits , C1 Total of A1-B1 then next line A2-B2 +C1 Thanks for any Help.....Bob Since your formula matches your subject line ... what's the question?  SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > > A1 Credits, B1 Debits , C1 Total of A1-B1 > then next line A2-B2 +C1 > > Thanks for any Help.....Bob Sorry if A2 and B2 don't have any data C2 should be blank........Thanks Bob > Since your formula matches your subject line ... what's the question? >> >> A1 Credits, B1 Debits , C1 Total of A1-B1 >> then next line A2-B2 +C1 >> >> Thanks for any Help.....Bob Hi Bob One way =IF(COUNT(A2:B2)=0,"",A2-B2 +C1) SignatureRegards Roger Govier > Sorry if A2 and B2 don't have any data C2 should be > blank........Thanks Bob [quoted text clipped - 4 lines] >>> >>> Thanks for any Help.....Bob Thanks Roger worked great Bob > Hi Bob > [quoted text clipped - 9 lines] >>>> >>>> Thanks for any Help.....Bob
|
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.