I've read about fills. I was hoping for a way to have the forumla apply no matter what, so I don't have to keep filling as I add more rows in the future. On Oct 9, 2013, at 7:00 AM, Nicholas Parsons <[email protected]> wrote:
> Hey Alex, > > Try this. > First, try flipping your table around. So, you have your headers across the > top row, at the top of each column: A1, B1, C1, D1, E1. Then, A2 might be, > for instance, date. B2 would be starting milage, C2 end milage, D2 excluded > milage. IN E2, type =C2-B2-D2. Not sure if this step is completely necessary, > but it makes better sense to me and it at least works. > Second, select all the cells in the total milage column. So, starting in E2, > hold shift and press the down arrow until you've selected all the cells in > that column you want to have a total. Then, navigate to the menu bar, Insert, > Fill, and choose down. That should give you the result you want. Fill > basically copies the formula from the starting cell, but modifies it so it's > relative to the cell being filled, if that makes sense. You probably can do > this around the other way you had originally, using fill right instead of > fill down, but I'm not sure how that would go with headers. > Cheers, > Nic > > -- > 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 http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/groups/opt_out. Have a great day, Alex (msg sent from Mac Mini) [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 http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/groups/opt_out.
