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

G

Guest

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

Bob Phillips

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

Just concatenate the comparison operator to the range.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtotal with sumif nested 1
SUMIF with criteria "<>" & "=" 4
sumif wildcard criteria 1
Sumif using Arrays 2
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Sumif Multiple Columns 2
SUMIF partial string criteria 4
Sumif with Multiple Criteria 3

Top