# Re: SUMIF Question

*From*: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>*Date*: Thu, 28 Sep 2006 13:02:52 -0500

=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

.

**References**:**SUMIF Question***From:*Owen888

- Prev by Date:
**Re: Hide rows** - Next by Date:
**Re: SUMIF Question** - Previous by thread:
**SUMIF Question** - Next by thread:
**Re: SUMIF Question** - Index(es):