+ Reply to Thread
Results 1 to 5 of 5

SumIfs and Month Function

  1. #1
    Registered User
    Join Date
    03-31-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    SumIfs and Month Function

    Dear Excel Helpers

    I'm trying to build a simple budget manager with the following columns

    Expenses Date Category

    Once I'll have different months and different categories I would like to have a formula that can calculate the sum of the expenses in a month in a certain categorie....

    I was trying to use somm.Ifs and Month but I can't put this formula working....can you help me please?

    Thank you so much!

    PedroBudget Manager.xlsxBudget Manager.xlsx

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: SumIfs and Month Function

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS
    Last edited by TMS; 12-28-2014 at 07:37 PM.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-31-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: SumIfs and Month Function

    Hi Dear TMS,

    I can make this word I don't know why...I used the formula as it is...

  4. #4
    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,893

    Re: SumIfs and Month Function

    Try this out.
    Attached Files Attached Files
    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

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: SumIfs and Month Function

    =SOMARPRODUTO(--(MĘS($C$4:$C$15)=1),--($D$4:$D$15="Food"),($F$4:$F$15))
    if your excel is in Portuguese
    or maybe your separator is set to ; not ,
    =SUMPRODUCT(--(MONTH($C$4:$C$15)=1);--($D$4:$D$15="Food");($F$4:$F$15))
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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 error while using month function.
    By sktneer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-31-2018, 06:01 AM
  2. Sumifs with a month
    By pbt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2014, 04:30 PM
  3. SUMIFS used with month ?
    By spookiepower in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-29-2013, 06:44 AM
  4. [SOLVED] Use TEXT function as Criteria on Sumifs to convert month/year to date format
    By chico.corrales in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-08-2012, 07:49 PM
  5. Help With SUMIFS by Month
    By dsarkissian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2012, 08:48 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