Yes, I believe that all row and column headers are automatically named ranges.
In Excel, one can also create ranges by selecting a group of cells when in a
formula or by using two locations separated by a colan. I expect these
behaviors would work in numbers as well.
Best wishes,
Jonathan Cohn
> On Jul 2, 2017, at 2:59 PM, Jeff Berwick <[email protected]> wrote:
>
> Hi all,
>
> Trying to build myself a new budget and I thought I’d take a look at the
> template that comes with Numbers. In one of the cells, the following formula
> appears:
>
> SUMIF(Category,A2,$Amount)
>
> From what I understand, “Category” would refer to where to look for the
> value, a2 refers to the actual value and $amount refers to the numeric value
> associated with the found value.
>
> Voiceover reports that both “Category” and “$amount” are ranges.
>
> My question is, how can I figure out where these ranges point and how do you
> create a range?
>
> Tia,
> Jeff
>
>
> --
> The following information is important for all members of the Mac Visionaries
> list.
>
> If you have any questions or concerns about the running of this list, or if
> you feel that a member's post is inappropriate, please contact the owners or
> moderators directly rather than posting on the list itself.
>
> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at:
> [email protected] and your owner is Cara Quinn - you
> can reach Cara at [email protected]
>
> The archives for this list can be searched at:
> http://www.mail-archive.com/[email protected]/
> ---
> You received this message because you are subscribed to the Google Groups
> "MacVisionaries" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/macvisionaries.
> For more options, visit https://groups.google.com/d/optout.
--
The following information is important for all members of the Mac Visionaries
list.
If you have any questions or concerns about the running of this list, or if you
feel that a member's post is inappropriate, please contact the owners or
moderators directly rather than posting on the list itself.
Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at:
[email protected] and your owner is Cara Quinn - you
can reach Cara at [email protected]
The archives for this list can be searched at:
http://www.mail-archive.com/[email protected]/
---
You received this message because you are subscribed to the Google Groups
"MacVisionaries" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/macvisionaries.
For more options, visit https://groups.google.com/d/optout.
