Results 1 to 8 of 8

Sumifs range in number corresponding to the month

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-07-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    372

    Sumifs range in number corresponding to the month

    HI,

    How do sumifs ranges in number corresponding to the month.

    Data:

    Document Date Plant Amount
    01.04.2015 3100 5432.26
    01.04.2015 3100 4203.28
    01.04.2015 3100 915.61
    01.04.2015 3100 22220.82
    01.04.2015 3190 2655.81
    01.04.2015 3190 254.67
    01.04.2015 3700 8012.41
    01.04.2015 3700 5521.92
    01.04.2015 3700 8919.29

    Req Format:

    PLANT CODE
    Month:Apr.15
    A B C D

    3100 3190 3700 58136.07

    Am apply this formula

    =SUMIFS('APRIL-15'!$C$2:$C$22294,'APRIL-15'!$B$2:$B$22294,REQFORMAT!$A3&REQFORMAT!B3&REQFORMAT!C3,'APRIL-15'!$A$2:$A$22294,">="&EOMONTH(REQFORMAT!$D$2,-1)+1,'APRIL-15'!$A$2:$A$22294,"<="&EOMONTH(REQFORMAT!$D$2,0))

    value return is wrongly when range multiple.

    please help me. file attached.
    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. [SOLVED] How do sumifs from to range in number corresponding to the month
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2015, 07:50 AM
  2. [SOLVED] SumIfs that cannot sum the Date to its month range
    By JESSHOR60 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2015, 07:18 PM
  3. [SOLVED] Using SUMIFS to count the number of inquiries per month based on the date of inquiry
    By Tryin2Excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2014, 04:11 AM
  4. [SOLVED] Sumifs and extracting month from range
    By Andrew-Mark in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2013, 07:12 AM
  5. Count number of events per month in a range
    By cpots13 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-27-2013, 04:03 PM

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