Sumif with AND statements

[Cdworks]

Good day!

I am somewhat new to excel i have the basic excel skills and am working on an excel file to produce a production calendar from a quickbooks export.

I am needing to do a sumif statement for a range between two dates.

sum if ( X:Z, Date1>=date2 and <= date3, Sum range)

Could anyone help me with this?

TIA
- CDWorks

 

[Cdworks]

That got it thanks!

 

[T. Valko]

That got it thanks!

Good deal.

Ok, for your second question...

The easiest way to do this is to use the autofilter on the date column then copy the filtered data to the other location.

Select the entire range of data in question
Goto the menu Data>Filter>Autofilter
Click the drop arrow on the date column
Select: Custom
In the top left drop down select: is greater than or equal to
In the top right drop down enter 1/1/2011 (or whatever)
Select: And
In the bottom left drop down select: is less than or equal to
In the bottom right drop down enter 1/5/2011 (or whatever)
OK

Then just select the visible data and copy/paste.

 

[Cdworks]

Thats what I Ended up doing. Like I said I was over complicating things.

Thank you for all the help!

 

[T. Valko]

Thats what I Ended up doing. Like I said I was over complicating things.

Thank you for all the help!

You're welcome. Thanks for the feedback!