+ Reply to Thread
Results 1 to 5 of 5

SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR

  1. #1
    Forum Contributor
    Join Date
    09-02-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    116

    SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR

    Hi

    Im trying to compare weekly sales figs by week number, month number, quarter number and tax year.
    Tax year is 1st April - 31st March on all years. Week runs Monday to Sunday. I have attached the data but not sure what formula or pivot table will provide all the comparisons i need, can anyone help?

    Many Thanks in advance

    Dave
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR

    Put the below in cell J4 then copy down and across as needed.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Forum Contributor
    Join Date
    09-02-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    116

    Re: SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR

    Hi
    I pasted the formula but it comes up with an error, when I open the sumifs function arguments box it says Sum Range, Criteria range 1 and criteria range 2 are invalid?
    Dave

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR

    is that what you want?
    I did it via PowerQuery - no formula, no vba
    Attached Files Attached Files

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR

    Quote Originally Posted by faodavid View Post
    Hi
    I pasted the formula but it comes up with an error, when I open the sumifs function arguments box it says Sum Range, Criteria range 1 and criteria range 2 are invalid?
    Dave
    Works just fine for me.

    BSB
    Attached Files Attached Files

+ 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. Return Value to Month-Year and Week Number
    By bambino86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2017, 12:59 AM
  2. [SOLVED] Locating beginning and end of week, month, quarter or year balance
    By ehollifield in forum Excel General
    Replies: 10
    Last Post: 03-29-2017, 02:00 PM
  3. [SOLVED] Calculate Week Range from Week Number, Month and Year?
    By A108A108 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-07-2016, 03:11 PM
  4. Replies: 4
    Last Post: 08-05-2015, 06:39 PM
  5. Excel 2007 - Comparison of monthly sales year on year
    By djr1970 in forum Excel General
    Replies: 7
    Last Post: 08-12-2014, 01:56 PM
  6. [SOLVED] Making Daily Sales Planner recognize which month and which week to pull sales data from
    By Topher53180 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2014, 10:33 AM
  7. Calculate # of sales per week, month & quarter
    By AlcatrazT2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 06:25 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