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

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.

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

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

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