+ Reply to Thread
Results 1 to 5 of 5

Monthwise average

  1. #1
    Registered User
    Join Date
    07-07-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    13

    Post Monthwise average

    I want month wise average as Jan feb march etc.
    PQA and PMQ lead time
    Marked in yellow field.
    attached file for reference.
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,832

    Re: Monthwise average

    You are using text in below formula in column AE


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


    Don't convert number into text other wise you will get error or wrong result.

    Change "1" in to 1 where applicable

    Average Formula will automatically work
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    07-07-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Monthwise average

    Dear Mr.Shukla,

    Thanks for quick response within 15 minutes after posting.
    Great.

    Thanks
    Last edited by ashokdd; 04-05-2018 at 09:32 AM. Reason: spell mistake

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: Monthwise average

    Try

    in AR2

    =IFERROR(AVERAGE(IF((MONTH($D$3:$D$215)=AR$8)*(YEAR($D$3:$D$215)=$H$1),$AE$3:$AE$215)),"")

    copy across

    CORRECT column AE as per Shukla's post.

    =IF(K3="","",IF(L3="","Under Inspection",IF(X3="","SES Not Sent",IF(C3="Not Booked","",IF(X3<=D3,1,(X3-D3))))))

  5. #5
    Registered User
    Join Date
    07-07-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Monthwise average

    Thank Mr.John for additional help,
    nice.

+ 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. Monthwise Data to come in one column
    By nits1982 in forum Excel General
    Replies: 6
    Last Post: 04-16-2016, 12:29 PM
  2. Monthwise Summary
    By anwitha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-18-2016, 12:48 AM
  3. Combo Box for doing sum monthwise from given data
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2014, 01:42 AM
  4. [SOLVED] Want to split week in monthwise (help)!!!
    By devpp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 01:47 AM
  5. Monthwise calclulation
    By vjharry in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-10-2013, 03:00 AM
  6. Sum of values for a date column monthwise
    By Rajnishbhatt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2008, 11:54 PM
  7. calculation sales monthwise
    By Rao Ratan Singh in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-01-2006, 08:35 AM

Tags for this Thread

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