ExcelBanter - sumif - looking to find text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sumif - looking to find text (https://www.excelbanter.com/excel-discussion-misc-queries/136638-sumif-looking-find-text.html)

tee

sumif - looking to find text

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?

All times are GMT +1. The time now is 05:04 AM.