Excel 2007 : SUMIFS on multiply text criertia

sumifs works perfectly fine when I use it for finding a number value in the cell.

But what if I need it to output a cell that has text.

I attached the formula I use when there is a value in a cell DY, is there a similar function that will use multiply text criteria to find the cell with text in DY.

=(SUMIFS('[09Dec.xlsx]WW'!$DY$6:$DY$10,'[09Dec.xlsx]WW'!$C$6:$C$10,B10,'[09Dec.xlsx]WW'!$D$6:$D$10,A10))

Try:

=INDEX([09Dec.xlsx]WW!$DY$6:$DY$10,MATCH(1,INDEX(([09Dec.xlsx]WW!$C$6:$C$10=B10)*([09Dec.xlsx]WW!$D$6:$D$10=A10),0),0))

this will find first match, if any. You can wrap in an IFERROR() to error trap...