+ Reply to Thread
Results 1 to 2 of 2

arange dates

  1. #1
    kabeer
    Guest

    arange dates


    hi i have lot of dates in colum A and every date has a price please
    ignore the colum C so i have date ranges in colum D and colum E which
    is prices is still empty, how can i get the sum of the prices in these
    date ranges , i mean i apply a formula which can give me the sum of the
    prices against colum D
    like
    08/22/2004 = 125000
    i hope u guys help me


    --
    kabeer

  2. #2
    Dave Peterson
    Guest

    Re: arange dates

    Total for each day???

    If yes, then sort by the date.
    then Data|subtotal (by that date column)

    You can use the outlining symbols to show/hide the details.



    kabeer wrote:
    >
    > hi i have lot of dates in colum A and every date has a price please
    > ignore the colum C so i have date ranges in colum D and colum E which
    > is prices is still empty, how can i get the sum of the prices in these
    > date ranges , i mean i apply a formula which can give me the sum of the
    > prices against colum D
    > like
    > 08/22/2004 = 125000
    > i hope u guys help me
    >
    > --
    > kabeer


    --

    Dave Peterson

+ 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