Results 1 to 7 of 7

sumifs + offset formula issue

Threaded View

jw01 sumifs + offset formula issue 02-11-2015, 10:25 AM
mcmahobt Re: sumifs + offset formula... 02-11-2015, 10:32 AM
jw01 Re: sumifs + offset formula... 02-11-2015, 10:41 AM
mcmahobt Re: sumifs + offset formula... 02-11-2015, 10:41 AM
jw01 Re: sumifs + offset formula... 02-11-2015, 10:47 AM
jw01 Re: sumifs + offset formula... 02-11-2015, 10:51 AM
mcmahobt Re: sumifs + offset formula... 02-11-2015, 11:05 AM
  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,233

    sumifs + offset formula issue

    hey all

    having some trouble with sumifs + offset formula. i have my data where it shows quantity by 2015, 2014, 2013.

    Through a drop down in "sheet1" cell C17, i want to be able to show the quantity by month for states/provinces.

    in "sheet1", cell D21 this is my formula:

    =SUMIFS((OFFSET(Data!$A$59,3,MATCH(Sheet1!$C$17&Sheet1!$C$18,Data!$D$61:$V$61,0)-1,359)),Data!$D$62:$D$7225,Sheet1!$C21,Data!$B$62:$B$7225,Sheet1!D$19)
    it is giving me #value error...can someone pls help?

    thank you - attached is the sample file.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dragging SUMIFS but need ranges to offset
    By LK0001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2014, 09:57 AM
  2. [SOLVED] SUMIFS with a dynamic, offset criteria range
    By adelcap in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2014, 05:35 AM
  3. SUMIFS Formula Issue
    By keithd203 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2013, 04:15 PM
  4. Help with OFFSET/MATCH/SUMIFS formula
    By brianjluke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2013, 10:02 AM
  5. User Defined Function using Sumifs, Offset, Match and CountA
    By PeterW2020 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2011, 02:29 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