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 |
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 |