Posts by zukbang

    Re: Sum cells based on date criteria


    AAE, thanks first time doing this kinda work since college...been so long.


    i'm using calendar control 10.0 from excel.
    basically what I would like to do is, I want to find out how many units are coming in in certain date.
    I kinda explained on my first post....I hope this explains a little more of my question.


    Thanks

    Hi guys,


    my first post and I'm very new to Excel. please help.


    here's what I want to do;


    from my excel sheet, certain dates have values and I want to add them up and show them on calendar when I click on that date.


    I have the calendar added already but couldn't find a way to do that..


    for example;


    a1-10/20/2010 a2-1000
    b1-10/19/2010 b2-2000
    c1-10/20/2010 b3-1500


    so when I click on 10/20 from the calendar, I would like an output of 2500.


    is this something feasible?


    thanks in advance