DATEVALUE used for Criteria range in SUMIFS formula

I have the following SUMIFS formula with multiple criteria. For the last criteria, I am trying to pull the data that is greater than or equal to a date in column E. Problem is that column E is format as text from an external download. I tried to add DATEVALUE to the formula but I cannot enter the formula as it is written below (I get this formula contains an error).

If I remove the DATEVALUE part of the formula, I can enter the formula, but it doesn't return data because the criteria range dates are text and the criteria is date format. I am trying to achieve this by not having to add a helper column with the dates converted to date or modifying the extenal data format

=SUMIFS($J:$J,$A:$A,$N60,$D:$D,$P60,$F:$F,$R60,$G:$G,">="&$T60,$H:$H,">="&$U60,$I:$I,$V60,datevalue($E:$E),">=”B56)

HELP!!

hi heatherromo, hmmmm i dont know if Excel allows u to convert the range to DATEVALUE. it's definitely possible if u put a DATEVALUE formula in say column S to convert the whole Column E. and then change your formula to:
=SUMIFS($J:$J,$A:$A,$N60,$D:$D,$P60,$F:$F,$R60,$G:$G,">="&$T60,$H:$H,">="&$U60,$I:$I,$V60,datevalue($S:$S),">=”&B56)

also, u must add in "&" after ">="

do upload a file for us to try if it doesnt work