Results 1 to 24 of 24

Increment column address while copying formula down

Threaded View

needhelp93 Increment column address... 04-27-2014, 05:45 AM
Tony Valko Re: Need help with a formula 04-27-2014, 05:55 AM
Tony Valko Re: Need help with a formula 04-27-2014, 06:06 AM
Richard Buttrey Re: Need help with a formula 04-27-2014, 06:06 AM
needhelp93 Re: Increment column address... 04-27-2014, 06:20 AM
Tony Valko Re: Increment column address... 04-27-2014, 06:40 AM
needhelp93 Re: Increment column address... 04-27-2014, 06:29 AM
Tony Valko Re: Increment column address... 04-27-2014, 06:38 AM
Tony Valko Re: Increment column address... 04-27-2014, 06:52 AM
sktneer Re: Increment column address... 04-27-2014, 06:30 AM
needhelp93 Re: Increment column address... 04-27-2014, 07:32 AM
sktneer Re: Increment column address... 04-27-2014, 07:54 AM
needhelp93 Re: Increment column address... 04-27-2014, 07:46 AM
needhelp93 Re: Increment column address... 04-27-2014, 07:46 AM
Tony Valko Re: Increment column address... 04-27-2014, 10:21 AM
needhelp93 Re: Increment column address... 04-27-2014, 08:09 AM
sktneer Re: Increment column address... 04-27-2014, 08:22 AM
needhelp93 Re: Increment column address... 04-29-2014, 01:30 PM
Tony Valko Re: Increment column address... 04-29-2014, 03:25 PM
needhelp93 Re: Increment column address... 04-29-2014, 03:48 PM
Tony Valko Re: Increment column address... 04-29-2014, 04:07 PM
Tony Valko Re: Increment column address... 04-29-2014, 07:26 PM
needhelp93 Re: Increment column address... 05-05-2014, 11:43 AM
Tony Valko Re: Increment column address... 05-05-2014, 03:12 PM
  1. #1
    Registered User
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    10

    Increment column address while copying formula down

    I am creating a training document for work; the sheet I'm creating is a summary sheet which works out how many people answered questions correctly, incorrectly (bringing in from another sheet), number of questions answered and percentage of correct answers.

    Looks like:
    Correct: =COUNTIF(sheet1!E2:E36,"correct")
    Incorrect: =COUNTIF(sheet1!E2:E36,"incorrect")
    Number of questions answered: =SUM(C4+C5) (correct+incorrect)
    Percentage right: =SUM(C4/C6) (correct/number answered)

    I need to drag these 4 formulas down into another 400+rows, however in the correct and incorrect formulas I need it to keep the 2:36 but change the e to f, g, h, etc…
    Is this possible? Thanks
    Last edited by needhelp93; 04-27-2014 at 06:19 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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