+ Reply to Thread
Results 1 to 3 of 3

sumif & countif formula needed based on dd/mm/yy format - worksheet attached

  1. 12-28-2013, 01:14 AM #1
    excelteam777
    excelteam777 is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    sumif & countif formula needed based on dd/mm/yy format - worksheet attached

    Ok, attached is the worksheet. I have 2 sheets I am working with.

    1st:
    I simply want count the number of times an entry is entered on sheet1 into C6:C10 based on the
    month entered into B6:B10 using format dd/mm/yy, and have the answer on sheet2 in the corresponding month from D4:D15

    2nd:
    I want to repeat the same steps but this time I want to sum the totals from G6:G10 on sheet1
    based on the month entered into B6:B10 using format dd/mm/yy, and have the answer on sheet2 in the corresponding month from E4:E15
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-28-2013, 03:25 AM #2
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: sumif & countif formula needed based on dd/mm/yy format - worksheet attached

    sumif-countif sample_122713.xlsx
    C4
    1/1/13 drag down to fill months
    Custom Format "mmm"
    D4
    =COUNTIFS(sheet1!$B$6:$B$1000,">="&sheet2!C4,sheet1!$B$6:$B$1000,"<="&EOMONTH(sheet2!$C4,0))
    E4
    =SUMIFS(sheet1!$G$6:$G$1000,sheet1!$B$6:$B$1000,">="&sheet2!C4,sheet1!$B$6:$B$1000,"<="&EOMONTH(sheet2!$C4,0))
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk
    Reply With QuoteRegister To Reply
  3. 12-28-2013, 11:32 AM #3
    excelteam777
    excelteam777 is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Re: sumif & countif formula needed based on dd/mm/yy format - worksheet attached

    works great, thx
    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] Formula needed for countif and sumif based on date format 12/23/13, etc.
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-28-2013, 10:50 AM
  2. [SOLVED] Formula needed for counting cells based on today's date - see attached worksheet
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-16-2013, 07:06 PM
  3. Worksheet Attached - Formula needed to calculate commissions vs date and Emp ID #
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-02-2013, 12:36 AM
  4. COUNTIF & SUMIF formulas needed when decided based on entry into 2 cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2013, 07:58 PM
  5. [SOLVED] COUNTIF or SUMIF Formula based on other column value needed urgently please?
    By jamieswift1977 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2013, 05:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1