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))
Bookmarks