+ Reply to Thread
Results 1 to 2 of 2

SUMIF by months

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    Klaipeda, Lithuania
    MS-Off Ver
    Microsoft Office 2017
    Posts
    51

    SUMIF by months

    Hello,
    I can‘t find a solution how to sum values of selected category by months.
    For example I have categories: CAR, GIFTS and BOOKS.

    Date Category Sum
    12/01/2019 Car 6
    16/01/2019 Gifts 5
    16/01/2019 Car 4
    23/01/2019 Books 7
    12/02/2019 Car 2
    19/02/2019 Books 10

    I want to calculate how much I spent for CAR in January and in February, how much I spent for BOOKS and GIFTS by month
    Can anyone help me

    Thank you

  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,091

    Re: SUMIF by months

    Use a Pivot Table.
    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


+ 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] Sumif months?
    By PedroSchulz in forum Excel General
    Replies: 4
    Last Post: 10-08-2014, 02:43 PM
  2. [SOLVED] SUMIF for Dates / Months ?
    By Rowan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 09:05 PM
  3. [SOLVED] SUMIF for Dates / Months ?
    By ZMAN in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  4. SUMIF for Dates / Months ?
    By Rowan in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-06-2005, 05:05 AM
  5. SUMIF for Dates / Months ?
    By ZMAN in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] SUMIF for Dates / Months ?
    By ZMAN in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. SUMIF for Dates / Months ?
    By ZMAN in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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