+ Reply to Thread
Results 1 to 5 of 5

Sumifs function not returning any value

  1. #1
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Sumifs function not returning any value

    Hi,

    So, on one tab of my spreadsheet Average6Weeks, I have a 6 week average numbers for each product and also each product has its own tab.
    I want to pull over the value for each 6 weeks onto the matching product tab and also match each 6 week, but I do not have the formula correct. Can I get some assistance please?
    Thanks
    Attached Files Attached Files
    ==========
    Bigroo1958
    Austin, Texas
    ==========

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,892

    Re: Sumifs function not returning any value

    I'm not clear what your expected answer is...

    maybe this in m4???

    =SUMPRODUCT((Average6wks!$B$4:$H$8)*(Average6wks!$A$4:$A$8=ProductA!$B$1))
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Re: Sumifs function not returning any value

    Hi Glenn,

    Thanks for the reply!
    Ok, no, I don't want to total the 6 weeks, I want each value for example, week 21 values from the Average 6 weeks tab to match the product Tab and the week number on each product tab and show the value under week 21 etc.
    I hope this is more clear!
    Thanks
    Attached Files Attached Files
    Last edited by bigroo1958; 07-15-2018 at 08:39 AM. Reason: Upload new example

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Sumifs function not returning any value

    =SUMPRODUCT((Average6wks!$B$4:$H$8)*(Average6wks!$A$4:$A$8=ProductA!$B$1)*(Average6wks!$B$3:$H$3=ProductA!M3))

  5. #5
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Re: Sumifs function not returning any value

    Hi Phuocam,

    Thanks, that did the job and as requested.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] SUMIFS returning 0
    By ninemuses0 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-04-2020, 07:25 AM
  2. Please help! Using SUMIFS but returning 0
    By feelinglikeanoob in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-14-2016, 08:03 PM
  3. sumifs returning 0's
    By rcdavis28 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-26-2016, 04:12 PM
  4. [SOLVED] SUMIFS returning #VALUE
    By mglassco in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-06-2013, 06:45 PM
  5. SUMIFS returning #VALUE!
    By HarvardMajesty in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-27-2013, 10:35 PM
  6. [SOLVED] sumifs function returning 0 error...
    By courage in forum Excel General
    Replies: 9
    Last Post: 04-09-2012, 06:49 PM
  7. SUMIFS returning #VALUE!
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2011, 08:59 AM

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