Excel 2007 : 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!

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

Pete

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.

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:

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.