View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ulupi ulupi is offline
external usenet poster
 
Posts: 2
Default Why does this formula =SUM(AJ3:AJ410) not add up/total correctly?

Column AJ has cells that either contain "1" or are blank but the folrmula
returns a value of "0".

All cells including the cell containing the formula are formatted for Numbers.