I currently use the following formula

=SUMPRODUCT(($J$5:$J$4000=$T$4007)*($AS$5:$AS$4000 <0)*($AS$5:$AS$4000))

But it does not seems to work if the value in column J is formated as text (
ex 3644 or '3644)

Is there a way to modify the formula so that it does not matter if the value
in column J is foramted as a number or text?

Thanks

ce