Skip navigation

Formula Help

231 Views 2 Replies Latest reply: Dec 9, 2012 5:33 PM by Souad H RSS
Souad H Level 1 Level 1 (95 points)
Currently Being Moderated
Dec 9, 2012 2:32 PM

Hi,

I would like to add a formula to G. Is there a way to do it for all of the cells that are in G one time?

Thanks

I'm using Numbers '09 Version 2.3

              OS X 10.7.5

Screen Shot 2012-12-09 at 4.28.16 PM.png

MacBook Pro, Mac OS X (10.7)
  • Wayne Contello Level 6 Level 6 (12,560 points)
    Currently Being Moderated
    Dec 9, 2012 3:16 PM (in response to Souad H)

    Souad,

     

    this may help you get start,

     

     

     

    Screen Shot 2012-12-09 at 5.10.57 PM.png

    Enter formula as shown in image above:

     

    G2=B2+D2+E2

     

    No select G2, copy

    Screen Shot 2012-12-09 at 5.11.13 PM.png

     

    Now select the cells G3 tho the end of the column (as shown)

     

     

    Screen Shot 2012-12-09 at 5.11.31 PM.png

    Now paste.  The formula will fill and automatically adjust by row so that each cell of column G sums the corresponding cells in columns B, D, and E

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.