SUMIF Question
 

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)

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

SUMIF Question
 

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)

SUMIF Question
 

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


--
HTH

Bob Phillips

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

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

SUMIF Question
 

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"

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