+ Reply to Thread
Results 1 to 3 of 3

Sumif based on month

  1. #1
    Registered User
    Join Date
    06-30-2018
    Location
    Azerbaijan
    MS-Off Ver
    Excel 2016
    Posts
    82

    Sumif based on month

    Hey dear comminuty,

    I wanna know how can i add month criteria to this sumif formula.

    Dates in table are like this 27-09-2019

    How can i sum all september orders?

    .FormulaArray = "=sum(if((isnumber(match(urun,market,0)))*(order>0)*(product<>"""")*(not(isnumber(match(column1,column2,0)))),amount))"

    Can anyone help me please?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,741

    Re: Sumif based on month

    why not use the built in Function =Sumifs

    Here is a link https://www.techonthenet.com/excel/formulas/sumifs.php

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,179

    Re: Sumif based on month

    you can use a formula to determine the month.

    e.g.

    B2=Month(a2)

    After that you can use a pivot table.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Sumif based on column headers from source tab that move month over month
    By VlookupMyName in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2018, 07:10 PM
  2. Sumif same cell on sheets based on month
    By earthandbody in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2017, 02:15 PM
  3. SUMIF a month name based on a column of dates
    By lorber123 in forum Excel General
    Replies: 3
    Last Post: 06-24-2016, 09:25 PM
  4. [SOLVED] Sumif/Sumproduct based on Specific dates occurring in any given month
    By Kandy1084 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2015, 03:08 PM
  5. [SOLVED] display cell to show only Month/year to do sumif calc if today()= any day of month
    By fireguy7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 06:55 PM
  6. [Solved] SUMIF based on dates (month)
    By Russell719 in forum Excel General
    Replies: 4
    Last Post: 10-19-2010, 01:30 PM
  7. SUMIF of a RANGE NAME BASED ON MONTH
    By Big_Tater in forum Excel General
    Replies: 2
    Last Post: 05-25-2010, 04:31 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