Follow this topic

Nguhemen Tingir

Last answered:

20 Dec 2023

Posted on:

19 Dec 2023

1

Resolved: Formula not working

in Introduction to Excel / Using Named Ranges to Make Formulas More Readable

I keep getting the error #Name? when i try to sum. I have checked the formula to be sure it's correct and it is.

2 answers ( 1 marked as helpful)

Nguhemen Tingir

Posted on:

19 Dec 2023

0

Sorted it out. You have to hit enter after naming each cell range.

Helpful answer

Instructor

Posted on:

20 Dec 2023

0

Great work!

Submit an answer

related questions

Panagiotis Blatsas

0

12

Index and Match exercise tried the exact formula yet all results are N/A?

Asmaa Abdulhamid

0

12

the shortcut for creating a filter did not work for me

1

10

After finished this course, will i get a certificate or not?

2

10

The feature is not working

1

8

Resolved: I face with "File not found!" error.

0

8

Practice Exam 1 asked questions on material not covered

0

6

Course not moving forward.

0

6

Resolved: Excel practice exam 3 - not clear solution

Ahmed r. j. Hassan

1

6

hi..i did not understand from the minute 1:4 to the end ...

Prince Obeng Opare

0

6

Video Not playable

1

6

Hi. Are you using some key combination to put the $ sign in your formula?

Charles Acheampong

0

6

Resolved: Custom cell formatting not working