View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bradley
 
Posts: n/a
Default 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