View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Adam Lawrence Acoustics[_2_] Adam Lawrence Acoustics[_2_] is offline
external usenet poster
 
Posts: 3
Default SumIf not working over a long range

Thanks,

I know about the + and know its redundancy, its just an easy keyboard way of
automatically getting into formula mode. I accept there's probably another
easy way of doing this.

The cells in the columns are pulled from another part of the spreadsheet
which rounds to one decimal place, so I know they are all 0.1's and -0.1's,