View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
owl37
 
Posts: n/a
Default Why does a sumif use double speech marks

Hello,
I have created a sumif formulas as follows:

=SUMIF(E10:E21,"10",E10:E21)

My question is why do you have to have the double speech marks around the 10?
This doesn't seem to be needed in other formulas.
Any ideas out there?
Thanks.