Results 1 to 10 of 10

why the formula is not being copied to the bottom cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2019
    Posts
    545

    why the formula is not being copied to the bottom cells

    see the attached file. the total is on H3. when i drag the total to downwards i do not get the correct result.on H3 it is supposed to be the total of D3:G3. but from D4:G4,it not like that. so the error.

    when i drag the total to downward from H3, I get 58 in all the cells which is wrong. now i would like to know why this happens and how can edit it to get the correct result from H4 downwards.

    i have copied and pasted the values from another sheet. thanks
    Attached Files Attached Files
    Last edited by sumesh56; 10-08-2014 at 11:34 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 07-26-2014, 06:12 AM
  2. Sort Cells that contain Formula results need blank cells at the bottom
    By Vicious00013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-26-2014, 09:08 PM
  3. Replies: 1
    Last Post: 03-29-2014, 09:56 AM
  4. Data sort, empty formula cells to bottom merged cells!
    By ikkuh in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-09-2013, 03:10 AM
  5. paste copied data from bottom to top
    By refreshplease3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2006, 09:12 AM

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