+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Copying / Editing Conditional SUM!!! Formulas...

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    Crown Point, Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Copying / Editing Conditional SUM!!! Formulas...

    I'm pulling data from a checkbook I have setup on one sheet to produce monthly financial statements on another sheet... The identifiers are the "Account Type" and "Date Range".

    Simple enough but the problem occurs when I try to copy the formulas over. What I'd like to do is copy the formula over, do a lookup and replace the dates for the according columns, but once I copy the formula over there is an error.

    Who can help me out and save me a lot of time???

    Your helps is very much appreciated!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,070

    Re: Copying / Editing Conditional SUM!!! Formulas...

    Attach a sample file, and then we can see exactly what the problem is.

    Pete

  3. #3
    Registered User
    Join Date
    07-10-2012
    Location
    Crown Point, Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Copying / Editing Conditional SUM!!! Formulas...

    So again...I'm pulling numbers from the Check Register to the Buddys Winfield tab... and when I try to copy formulas over and change the dates there is an error.
    Attached Files Attached Files

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

    Re: Copying / Editing Conditional SUM!!! Formulas...

    I think, unless you need backward compatability to earler Excel versions, you should be using SUMIFS().

    Try this in E3 (note that you need to drop the s from Deposits in cell C3):

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    drag that down to E4.

    Note also that I changed the use of DATEVALUE() to DATE() as it doesn't rely on regional settings. If you had actual dates in the column headers it would be easier for you.

+ 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