Results 1 to 6 of 6

summing based on a criteria but the criteria is not the format i want

Threaded View

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Auckland
    MS-Off Ver
    Excel 2010
    Posts
    36

    summing based on a criteria but the criteria is not the format i want

    Hi there

    hopefully the question is in the title: summing based on a criteria but the criteria is not the format i want
    I have come up with a solution in Sheet1A but i don't want to add another column.
    Please ask any question if the question is not clear.

    See the attached.
    1. How do I get the sum of ValueA for the month of June and put it in column G2
    2. Assume that hourly data will be appended to this so in future I will want to get July values…etc
    3. I am looking to do the same for ValueB & ValueC
    4. I could add another column in column as I have done here and this works (Answer I want is in column J) see Sheet1A


    Row Labels	ValueA	ValueB	ValueC			Month I want
    8/06/2013 2:00	2	89	21			0
    8/06/2013 3:00	30	81	66			
    8/06/2013 4:00	65	89	58			
    8/06/2013 5:00	24	85	57			
    8/06/2013 6:00	100	86	60
    Tks
    Attached Files Attached Files
    Last edited by uimhirADo; 07-01-2013 at 04:25 PM.

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