+ Reply to Thread
Results 1 to 2 of 2

Sumproduct by month

  1. #1
    Registered User
    Join Date
    01-05-2021
    Location
    perth
    MS-Off Ver
    office 2016
    Posts
    3

    Sumproduct by month

    Hello
    I am trying to list and sum totals by month by description (list by month totals for "new house morgage") (i know the spelling is incorrect)

    Any help with formula would be greatly appreciated.

    ThanksScreenshot 2021-01-06 094824.jpg

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070

    Re: Sumproduct by month

    Hello,

    Have you tried to insert a pivot table ?

    Very simple ... and Extremely Powerful

    For explanations, see : https://www.contextures.com/xlpivot07.html
    Last edited by Carim; 01-06-2021 at 03:35 AM.
    HTH
    Carim


    Top Excel Links

+ 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. Sumproduct by month
    By mmasonspg in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-06-2021, 03:23 AM
  2. [SOLVED] Month Over Month Headcount with SUMPRODUCT
    By kdalyveris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2020, 04:55 PM
  3. [SOLVED] Using SUMPRODUCT & MONTH
    By kriscons in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2017, 10:39 AM
  4. [SOLVED] Sumproduct Month VBA
    By hanif in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2016, 11:52 AM
  5. SUMPRODUCT - Month AND Year
    By CarloF in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-19-2015, 12:58 PM
  6. Sumproduct, specific month
    By Luth6322 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2010, 02:53 AM
  7. [SOLVED] Problem with sumproduct and month=1
    By bobh727 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-15-2005, 04:06 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