+ Reply to Thread
Results 1 to 3 of 3

help: i need to input date range & 1 criteria then sumup

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    cebu
    MS-Off Ver
    Excel 2003
    Posts
    13

    help: i need to input date range & 1 criteria then sumup

    how to formulate in Total shares in cell "L"..
    first i need to check the date range from & to in cell "h" & "I" then the stock code in cell "k", into date in cell "a" & stock code in cell "b"... after all condition meet, i need to sum up share in cell "c" and return the value in cell "L".... thanks

    i have attached sample file..
    Attached Files Attached Files
    Last edited by go14344; 05-22-2012 at 02:34 AM.

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: help: i need to input date range & 1 criteria then sumup

    Try

    =SUMIFS($C$4:$C$300,$A$4:$A$300,">="&$H4,$A$4:$A$300,"<="&$I4,$B$4:$B$300,$K4)

  3. #3
    Registered User
    Join Date
    03-30-2012
    Location
    cebu
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: help: i need to input date range & 1 criteria then sumup

    thank bob...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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