sumif - looking to find text

T

Tee

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumproduct or sumif? 3
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA 3
sum multiple columns with SUMIF or SUMPRODUCT 3
SUMIF with criteria "<>" & "=" 4
sumif but additionally there maybe filtering 1
Sumif function 4
SUMIF not Iffing 3
SUMIF using date ranges & referencing account numbers 1

Top