 |
 | 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 / Worksheet Functions / June 2006IF= Cells not totaling
Hey all, I've got a column of equations [=IF(B3="S","3","")] that gives me 3's in each cell. When I go to AutoSum the column, I get a "0", not the total of 3's. This should be really simple. I want to add up what's showing in the cells, NOT the formula. Help? TIA! -b > I've got a column of equations [=IF(B3="S","3","")] that gives me 3's > in each cell. When I go to AutoSum the column, I get a "0", not the > total of 3's. You should write: =if(B3="S", 3, "") No quotes around 3. "3" with quotes is the string 3. 3 without quotes is the number 3. > Hey all, > I've got a column of equations [=IF(B3="S","3","")] that gives me [quoted text clipped - 6 lines] > TIA! > -b DOH! Got to change the "3" to 3. It was being read as a string.... -b Put this in your formula instead =IF(B3="S",3,"" -- Bearacad use either =IF(B3="S",3,"").........preferred or =IF(B3="S","3","")*1 Vaya con Dios, Chuck, CABGx3 > Hey all, > I've got a column of equations [=IF(B3="S","3","")] that gives me 3's [quoted text clipped - 6 lines] > TIA! > -b |
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
|
©2009 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.