If by "subject" you mean *subtract*, and without more information, assuming
the named ranges contain numbers, you could try:
=SUM(range1)-SUM(range2)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
How do you create a formula to subject one named range
from other in a worksheet?
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.