+ Reply to Thread
Results 1 to 4 of 4

how to sum up amount of books' price using "x" marked?

  1. #1
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    130

    how to sum up amount of books' price using "x" marked?

    hi guys,
    i had created a table of students' name with the amount they should paid after the books' prices .how to make excel sum up the books prices automatically after i key in "x" marked according book's title?please help.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,932

    Re: how to sum up amount of books' price using "x" marked?

    Try

    =SUMIF(I6:AE7,"X",$I$4:$AE$5)

    Any reason why you have merged 2 rows for each student rather than increase row height?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,567

    Re: how to sum up amount of books' price using "x" marked?

    You could use this, =SUMIF(I6:AE6,"x",$I$4:$AE$4) but I would get rid of the merged cells, they'll likely create problems.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: how to sum up amount of books' price using "x" marked?

    thank you.it's solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1