 |
 | 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 / December 2007Row formula help please
Hi, I need a formula that will add all figures in a row except zero or blank cells and then minus that figure from another cell figure - does anyone know how to do that please? thanks >Hi, I need a formula that will add all figures in a row except zero or blank >cells and then minus that figure from another cell figure - does anyone know >how to do that please? thanks =a2-row(1:1) --ron Thanks Ron, but that just minuses the row number from the cell figure rather than adding the row contents together then minusing it from the cell figure > >Hi, I need a formula that will add all figures in a row except zero or blank > >cells and then minus that figure from another cell figure - does anyone know [quoted text clipped - 3 lines] > > --ron managed to work it out - if anyone else needs it =a2-(sum(c2:m2)) >Thanks Ron, but that just minuses the row number from the cell figure rather >than adding the row contents together then minusing it from the cell figure [quoted text clipped - 6 lines] >> >> --ron You're correct. Typo Alert: Should have been: =a2-sum(row(1:1)) --ron Also: =A2-Sum(1:1)  SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > > >Thanks Ron, but that just minuses the row number from the cell figure rather [quoted text clipped - 15 lines] > > --ron |
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.