I would like to use a test of <RANGENAME in the criteria section of a sumif function?
R rftmst Sep 1, 2007 #1 I would like to use a test of <RANGENAME in the criteria section of a sumif function?
B Bob Phillips Sep 1, 2007 #2 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)
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)
G Guest Sep 1, 2007 #3 Just concatenate the comparison operator to the range. =SUMIF(rng1,"<" & rangename,rng2)
