The only critera you are looking at there is if J1 is greater than 6,000,000.

To find all numbers over 6000000 in that range use:
=SUMIF($J:$L,"6000000",$L:$L)

The plain english would be "For all values in columns J and L over six
million, add the value in the same row column L to the total"

"Owen888" wrote:

Does anyone know how to create a sumif formula with an expression in the
critria. Below is the formula I am trying to use.

Thanks!

=SUMIF($J:$L,$J1"6000000",$L:$L)