SUMIF Question

[Owen888]

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]

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

(I did change the ranges, though.)

 

[Biff]

My best guess:

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

Biff

 

[Bob Phillips]

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


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

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"