SOLVED

#NAME error

Copper Contributor

Hey there,

 

I'm pretty new to excel and just came across this error while playing around, can anyone explain to me what's the issue here? I'm pretty sure I entered the function in F2 correctly, but it keeps showing me the #NAME error even after creating the spreadsheet from scratch.

Thanks a lot!

 

Kind regards,

JakobBildschirm­foto 2023-03-06 um 14.18.13.pngBildschirm­foto 2023-03-06 um 14.18.27.png

1 Reply
best response confirmed by jakobzischka (Copper Contributor)
Solution

@jakobzischka 

Hey there, it's me again. I've figured out the problem, and in case anyone else ever gets the same error: I mixed up English and German. The course I was doing showed instructions for the English version of Excel, where the command is "SUM", but since my excel is set to German the command needs to be "SUMME". 

 

Cheers :)

1 best response

Accepted Solutions
best response confirmed by jakobzischka (Copper Contributor)
Solution

@jakobzischka 

Hey there, it's me again. I've figured out the problem, and in case anyone else ever gets the same error: I mixed up English and German. The course I was doing showed instructions for the English version of Excel, where the command is "SUM", but since my excel is set to German the command needs to be "SUMME". 

 

Cheers :)

View solution in original post