+ Reply to Thread
Results 1 to 20 of 20

Sum of Count On Monthly Interval

Hybrid View

  1. 06-19-2018, 02:31 PM #1
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Sum of Count On Monthly Interval

    is that what you want to achieve?


    I
    J
    K
    1
    		 Month Sum Avg
    2
    		 January
    240
    6.67


    or


    I
    J
    K
    1
    		 Month Sum Avg
    2
    		 January
    240
    6.67
    3
    		 February
    106
    2.94
    4
    		 March
    152
    4.22
    5
    		 April
    164
    4.56
    6
    		 May
    158
    4.39
    7
    		 June
    0
    0
    8
    		 July
    9
    		 August
    Last edited by sandy666; 06-19-2018 at 02:33 PM.
    Reply With QuoteRegister To Reply
  2. 06-19-2018, 02:35 PM #2
    Jnehra
    Jnehra is offline
    Registered User
    Join Date
    09-10-2017
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    63

    Re: Sum of Count On Monthly Interval

    That is EXACTLY what I am looking for Sandy!

    Can you please share your formulas?
    Reply With QuoteRegister To Reply
  3. 06-19-2018, 02:39 PM #3
    modytrane
    modytrane is offline
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Sum of Count On Monthly Interval

    Drag the formulas down to D294:E294
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane
    Reply With QuoteRegister To Reply
  4. 06-19-2018, 02:43 PM #4
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Sum of Count On Monthly Interval

    Quote Originally Posted by Jnehra View Post
    That is EXACTLY what I am looking for Sandy!

    Can you please share your formulas?
    sorry mate but this is a PowerQuery not a formula

    Power Query for
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count until certain interval reached
    By nkumala in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-31-2016, 12:55 AM
  2. Employee Count per Interval
    By sarahj84 in forum Excel Formulas & Functions
    Replies: 34
    Last Post: 08-12-2016, 11:40 AM
  3. Employee Count Per Interval
    By sarahj84 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-11-2016, 12:10 PM
  4. How to summarize 30mins interval raw data directly to Monthly Data
    By dedark05 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2016, 01:38 AM
  5. Filter column data by time interval and count the number of records for each interval
    By erictamlam in forum Excel General
    Replies: 1
    Last Post: 04-29-2014, 04:42 AM
  6. [SOLVED] get a count depending on the interval
    By Frazzle6 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-19-2014, 09:09 PM
  7. [SOLVED] count the number of events in an interval
    By invictus in forum Excel General
    Replies: 4
    Last Post: 06-11-2012, 06:17 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1