Results 1 to 3 of 3

Sumproduct Formula Issue

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2012
    Location
    Riverside
    MS-Off Ver
    Excel 2003
    Posts
    19

    Sumproduct Formula Issue

    Hey everyone I'm looking to use the sumproduct formula since I'm using excel 2003 to sum up the cells in column F (store variance) by day, month, and year. Here is what I have come up with so far but it does not seem to give me the information I need. Please help with this forumla it will be much appreciated.

    Thanks,

    Madahtter


    =SUMPRODUCT(--(DAY(Data!$J$2:$J$445)=B1),--(TEXT(Data!$H$2:$H$445,"mmm")=$A$2),--(YEAR(Data!$G$2:$G$445)=2012)*SUM(Data!$F$2:$F$445))
    Attached Files Attached Files

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