Hello all:
need to sum starting from B2 up to forever,
need to count all inside the b2,
i used this formula, but the numbers app can not accept it, can you tell me the reason?
=SUM(B2:B)
i went to the place that i need this formula to give me results, and hit paste, but nothing happened, also, i wrote anything to open the edit field, then i deleted and wrote my formula, but with no luck.
any help please?
By Ramy, 8 October, 2023
Forum
macOS and Mac Apps
Comments
I don't know if this will help.
Here's a pages article: https://support.apple.com/en-gb/guide/pages-icloud/gilcc8ecd809/icloud
I've used xl years ago and from what I'm reading, that should work, but it's been years so I am probably wrong.
will it apply to Numbers app?
where is the article? and will it apply to the numbers APp
Answer
=SUM(B)
Works in Numbers, I just tested it.
1. you create rows 1 as…
1. you create rows 1 as headings;
2. you enter in B1 e.g. Price;
3. you set yourself in (C) Cel;
4. You write: =SUM(B);
Thanks for the answer
FInally worked,
just =sum(B)
working.
Thanks
Remember
You can also do it horizontally, in other words, at the end, or beginning, or whatever's clever, of a Row.
oops.
I thought I posted the link.
I'll add it but your thread was answered correctly so that's good.