Your question is not clear to me. Initially you say you want to add a value
(singular) from a named cell (do you mean a cell with a Defined Name, or do
you just mean you want to specify the cell address?) but then you go on to
say you want to add values (plural) in AB that have data in AC... is there
any linkage between what you want to put in AB and what is in AC, or do you
just want to put the value(s?) in the first blank cell in AB where AC next
to it is not blank? I guess my main problem is I can't visualize your setup
from your description.

--
Rick (MVP - Excel)


"Joe" wrote in message
...
I have data elements in cols AC:AF. Data will be in rows from 5 to
whatever.
I need to add a value from another named cell in the worksheet into col
AB.
How do I do it so I only add values in AB that have data in AC?