View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SueB
 
Posts: n/a
Default Dealing with numbers that begin with a 0

Hello i am trying to figure out some basic sums but the forulas will not
differentiate between two numbers if one begins with a 0. in other words if i
enter the number 3 in a cell it give me the same results as if i entered a
03. i need it to be able to diffentiate between the two as they are two
seperate references.
=SUMIF(B$3:B$16,"03",A$62:A$75)