[Solved] Formula =SumH13:H27 and 1C pop up

[KevinDFarms]

Im trying to write a cell code, Trying to get the =SumH13:H27. and i keep getting a 1C pop up when i highlight all the cells i need to include. what am i doing wrong?

[RusselB]

Welcome to the Forums.
First off, your formula is missing required parentheses. The formula should look like

Code: Select all

=sum(h13:h27)

As to the pop-up, I don't recognize the term you're using to describe it. Maybe I know it using a different term.
Can you get a screenshot of it and attach it as part of a reply to this topic?
See How to attach a document for assistance regarding attaching a document, in this case the screenshot.

[MrProgrammer]

Trying to get the =SumH13:H27. and i keep getting a 1C pop up when i highlight all the cells i need to include. what am i doing wrong?

Type =, S, U, M, (, then highlight the cells, then ), Enter. Your problem is not the "pop up" but the missing parentheses which will cause a #NAME? error.

As to the pop-up, I don't recognize the term you're using to describe it.

It is perhaps the 15 R x 1 C dimension of the highlighted cells. I have used Calc for ten years but had no idea what a "1C pop up" might be until I tried the procedure myself.

Im trying to write a cell code …

You should read [Tutorial] Ten concepts that every Calc user should know. It will answer many questions that beginners have and make Calc less frustrating for you. Don't try to guess at formula syntax or how features work. Read the documentation. The Help menu will help you discover solutions on your own. The Help button in dialogs is very useful too.

A review of Write in clear, grammatical, correctly-spelled language will make further responses from me more likely.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.