Monday, March 21, 2011

SUM using names

You can use the names typed at the top of columns or side of rows in calculations simply by typing the name into the formula.

Try this example:
Go to cell C16 and then enter the formula =SUM(jan)
The result will show.
This formula can be copied to D16 and E16, and the names change to Feb and Mar.

I would request you to post here in the comment section.
Posted by at 11:34 PM

2 comments:

  1. chandarApril 1, 2011 at 1:54 AM

    have tried but not working .... & not found the path of setting also.

    using excel 2010

    ReplyDelete
  2. PrasadApril 6, 2011 at 5:04 AM

    Excel 2010 need to check. it worked in previous version, make sure "Accept Labels in Formula" should enabled in TOOLS, OPTIONS,CALCULATION

    ReplyDelete

Subscribe to: Post Comments (Atom)
Twitter Bird Gadget