+ Reply to Thread
Results 1 to 3 of 3

Need to add up data for weekly summary. SUMPRODUCT

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    2

    Need to add up data for weekly summary. SUMPRODUCT

    Hi. I joined a while back to get help with a spreadsheet but I managed to figure it out myself.
    Im now working on another spreadsheet and Im still struggling with what formula I should use and how to implement it. I believe SUMPRODUCT is what i need but I cant get it to work.

    Basically I want to sum up cells in a column F. But only for the rows where column A matches a date range and Column E says 'Pack'.

    Ive upload a snippet of the sheet can someone have a quick look?

    Ive took out all unnecessary columns and added comments to show exactly what Im trying to do. May make a bit more sense.

    Thanks for any help.

    Aaron.
    Attached Files Attached Files

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Need to add up data for weekly summary. SUMPRODUCT

    Hello Aaron,

    Try this formula in Sheet2 B4 copied across and down

    =SUMPRODUCT((Sheet1!$B$3:$B$77<=$A4)*(Sheet1!$B$3:$B$77>$A4-7)*(Sheet1!$E$3:$E$77="Pack"),Sheet1!F$3:F$77)

    Looks like you have calculation set to "manual" so you either need that to change to "automatic" or press F9 for totals to re-calculate
    Audere est facere

  3. #3
    Registered User
    Join Date
    08-02-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Need to add up data for weekly summary. SUMPRODUCT

    Thanks I wasn't expecting such a speedy response. I didn't realise it was such an active forum.

    Unfortunately ill need to wait until morning to give this a go now as I am not at work to use excel. Ill report back once I try it

+ 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