+ Reply to Thread
Results 1 to 3 of 3

Sumif or Sumproduct Data in month when data is represented in mmddyyyyy format

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Sumif or Sumproduct Data in month when data is represented in mmddyyyyy format

    Hi All,

    I have data for my team I have been able to retrieve data wise it using the sumproduct formula however now I am trying to capture this data for an entire month. I have tried several suggestion however had no success. Please advise.

    Associate ID Date Updates
    @B0814 Monday, October 01, 2012 0
    @C2942 Monday, October 01, 2012 194
    @D6400 Monday, October 01, 2012 15
    @E4063 Monday, October 01, 2012 44
    @E9539 Monday, October 01, 2012 58
    @B0814 Tuesday, October 02, 2012 0
    @C2942 Tuesday, October 02, 2012 0
    @D6400 Tuesday, October 02, 2012 101
    @E4063 Tuesday, October 02, 2012 40
    @E9539 Tuesday, October 02, 2012 55
    @B0814 Wednesday, October 03, 2012 0
    @C2942 Wednesday, October 03, 2012 249
    @D6400 Wednesday, October 03, 2012 210
    @E4063 Wednesday, October 03, 2012 247
    @E9539 Wednesday, October 03, 2012 153
    @B0814 Thursday, October 04, 2012 0
    @C2942 Thursday, October 04, 2012 127
    @D6400 Thursday, October 04, 2012 66
    @E4063 Thursday, October 04, 2012 137
    @E9539 Thursday, October 04, 2012 29

    I am trying to club all the dates when I select the month so that I get the complete data

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,123

    Re: Sumif or Sumproduct Data in month when data is represented in mmddyyyyy format

    you could add a helper column and use =month() to extract the month, then do a sumif() based on the month number
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-16-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Sumif or Sumproduct Data in month when data is represented in mmddyyyyy format

    Hi,

    Thanks you for your revert, I did try your suggestion and It worked.

    Is there a way I could do this without using the helper coloum by adding some formula with sumproduct or sumif?

    I am using the formula

    =SUMPRODUCT((Calculation!$D$2:$U$2=MTD!$C$37)*(Calculation!$A$158:$A$267=MTD!$E$34)*(List=MTD!$C$34)*(Calculation!K$158:K$267))
    Last edited by ankurkhandelwal1978; 11-19-2012 at 05:06 PM.

+ 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