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