| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF= 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF= Cells not totaling
Bradley wrote:
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF= Cells not totaling
Bradley wrote:
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 DOH! Got to change the "3" to 3. It was being read as a string.... -b |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF= Cells not totaling
Put this in your formula instead =IF(B3="S",3,"") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=553845 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF= Cells not totaling
use either
=IF(B3="S",3,"").........preferred or =IF(B3="S","3","")*1 Vaya con Dios, Chuck, CABGx3 "Bradley" wrote in message . .. 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Totaling Cells in Worksheets | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
