Please could someone give me some advice. This is a straightforward 'sumif'
formula. I can't seem to get it to return a text value. For example

Column A Column B Column C Column D

240770 Sumif(C1:C1000,A1,D1:D1000) 240770 Tina
270770 As above 270770 Dona

The formula just brings up a '0' and not the text ie: Tina or Dona

Any ideas?