SUMIF Question

O

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)
 
D

Dave Peterson

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

(I did change the ranges, though.)
 
B

Bob Phillips

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


--
HTH

Bob Phillips

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

~L

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"
 
Top