My best guess:

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

Biff

"Owen888" <u27266@uwe wrote in message news:66fa10fb6bb9e@uwe...
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)