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