Re: SUMIF Question



=SUMIF($J:$J,">"&6000000,$L:$L)
or
=SUMIF($J:$J,">"&$a$1,$L:$L)

(I did change the ranges, though.)

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)

--

Dave Peterson
.