#VALUE! result when using defined name in formula

T

Tacrier

I am learning how to name cells and use these names.

I tried to name a cell in my Summary sheet using the sum of cells in my
Detail sheet. When I press enter, the cell returns a #VALUE! What am i
doing wrong?

Trina
 
M

Max

That means there's a #VALUE! error in your sum range. Go check & clean it up,
the sum should work fine
 

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

using defined name in UDF 7
#VALUE! when using defined name 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel Count If Formula Question 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Sum across spreadsheets & ignore blanks to get rid of #VALUE! erro 6
Excel VBA 1
Trying to run excel vba code when cell value changes from empty to entered value. 1

Top