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
|