Can I use a named range in the criteria for a sumif?
 

I would like to use a test of <RANGENAME in the criteria section of a sumif
function?

Can I use a named range in the criteria for a sumif?
 

There is a very easy way to find out ... try it.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"rftmst" wrote in message
...
I would like to use a test of <RANGENAME in the criteria section of a sumif
function?

Can I use a named range in the criteria for a sumif?
 

Just concatenate the comparison operator to the range.

=SUMIF(rng1,"<" & rangename,rng2)


"rftmst" wrote in message
...
I would like to use a test of <RANGENAME in the criteria section of a sumif
function?