I am trying to get a value in excel where the criteria that has to be
satisfied are text in nature, but I do not what to type the text in the
formula but the cell reference.

I have use Sumif, If & And but no joy.

I hoping someone will be able to help.

Thanks
Tunde