I should probably just wait for someone who actually knows to answer, but based on my fiddling with the same template, Numbers seems to automatically make a range out of any row or column you assign a header to. The range is anything in the column that has the named heading.
> On Jul 2, 2017, at 1:59 PM, Jeff Berwick <mailingli...@berwick.name> 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: > macvisionaries+modera...@googlegroups.com and your owner is Cara Quinn - you > can reach Cara at caraqu...@caraquinn.com > > The archives for this list can be searched at: > http://www.mail-archive.com/macvisionaries@googlegroups.com/ > --- > 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 macvisionaries+unsubscr...@googlegroups.com. > To post to this group, send email to macvisionaries@googlegroups.com. > 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: macvisionaries+modera...@googlegroups.com and your owner is Cara Quinn - you can reach Cara at caraqu...@caraquinn.com The archives for this list can be searched at: http://www.mail-archive.com/macvisionaries@googlegroups.com/ --- 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 macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at https://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
