Results 1 to 13 of 13

Sumifs with dates

Threaded View

  1. #6
    Registered User
    Join Date
    07-02-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    49

    Re: Sumifs with dates

    The bow is the exact of my data, ( i don't know how to attach an excel file)

    DATE CODE AMOUNT
    1-Jan-19 d 200.00
    2-Jan-19 bc 100.00
    5-Jan-19 d 250.00
    20-Jan-19 bc 500.00
    30-Jan-19 d 500.00
    2-Feb-19 hd 100.00
    9-Feb-19 rp 500.00
    16-Feb-19 gf 300.00
    27-Feb-19 hd 2,000.00
    4-Mar-19 cb 50.00

    My answer data should be like


    CODE Jan-19 Feb-19 Mar-19 Apr-19
    D
    BC
    HD
    CB
    RP
    GF
    Last edited by Sajilpulath; 12-17-2019 at 04:26 PM. Reason: attach an ecel file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIFS Between 2 dates
    By Kcroft9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-20-2019, 12:11 AM
  2. SUMIFS using dates
    By dmoyle2019 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2019, 02:00 PM
  3. SUMIFS between 2 Dates
    By s0nicstang in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-04-2016, 04:06 PM
  4. [SOLVED] SUMIFS with two dates
    By Reapz in forum Excel General
    Replies: 8
    Last Post: 04-16-2015, 04:54 PM
  5. [SOLVED] Sumifs using dates help
    By shivernoz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2014, 12:41 PM
  6. SumIfs Between two dates
    By adam2308 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-01-2014, 11:31 AM
  7. [SOLVED] SUMIFS Between two dates
    By nsens in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-17-2013, 06:28 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