+ Reply to Thread
Results 1 to 6 of 6

Formula help for sheet to sheet countif / adding same page formula

  1. #1
    Registered User
    Join Date
    08-12-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    3

    Formula help for sheet to sheet countif / adding same page formula

    Hello, I am new to the forum so any help is appreciated in advance. I am trying to create a formula that will reference another sheet to add all items from column G based on a date range in column A. Then I need it to subtract from a cell on the original page. Here is the actual cells/needs:

    Formula will be housed in E9 on sheet 1
    It should reference sheet 2 and look for a specific date range within column A (7/30-8/5 for example)
    Once it has grouped by this data, I want it to add the values from column D (still sheet 2)
    Then I want it to subtract that total from C9 on sheet 1

    Not sure if I am missing information that anyone may need to help, but this is the gist of what I am trying to accomplish. The biggest problem I am having is getting the sheet to sheet referencing to not interfere with the formula, I am a relative novice with formula writing. Again, thanks in advance for any help anyone may be able to provide.

    JM

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,316

    Re: Formula help for sheet to sheet countif / adding same page formula

    without a workbook sample to see for sure, try using the =sumif() function, and see if that gets you started.

    if not, please upload a sample workbook, and i will help you further
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-26-2010
    Location
    Seattle Wa
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Formula help for sheet to sheet countif / adding same page formula

    You didn't indicate where the lookup date range could be found, but datevalue could be replaced with cell references
    =SUMPRODUCT((Sheet2!A2:A66>=DATEVALUE("07/30/2012"))*(Sheet2!A2:A66<=DATEVALUE("08/05/2012"))*(Sheet2!D2:D66))-C9

  4. #4
    Registered User
    Join Date
    08-12-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula help for sheet to sheet countif / adding same page formula

    Thank you very much! I will try to upload a sample this evening, time permitting.

  5. #5
    Registered User
    Join Date
    08-12-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula help for sheet to sheet countif / adding same page formula

    This worked perfectly. Thank you so much for your help! I tried to click the star but it didn't highlight, my apologies if this throws me out of compliance with the site's preferences!

  6. #6
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Formula help for sheet to sheet countif / adding same page formula

    @ Jon-Michael

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.
    I tried to click the star but it didn't highlight
    The star in Lancewr's post?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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