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
|