+ Reply to Thread
Results 1 to 1 of 1

logic to actually sum all the cvalues arising of a difference across the row

  1. #1
    all4excel
    Guest

    Question logic to actually sum all the cvalues arising of a difference across the row

    I need to have a logic to actually sum all the values arising of a difference across the row..

    For ex:-
    i have given a piece of work to different people and i want to check how many times they have reverted back to me..

    Col A Col B Col C Col D
    1st Query 1st Revert 2nd Query 2nd Revert Total
    11-Sep-07 12-Sep-07 13-Sep-07 15-Sep-07 3

    What i want is to minus (revert from query) and add all the days across the row..
    like 12-Sep-07 - 11-Sep-07 = 1 , 15-Sep-07 - 13-Sep-07 = 2
    and add the difference across the rows. 1+ 2 =3

    As good as writing= sum(h2-g2,j2-2,...so on..)

    but i will be having more columns and that is not going to be fixed

    so is it possible to have a logic to get the answer?.
    Last edited by all4excel; 09-12-2007 at 06:25 AM.

  2. #2
    all4excel
    Guest

    Attachment

    Please go thu the attachemnt.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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