searching between dates

[Joe@Willscot]

I am trying to find out how to look up data between two specific dates. i.e.
The amount of money that I have used from a specific account between 1 Jan 09
to 28 Feb 09?

 

[Bill Kuunders]

Have a look at http://www.xldynamic.com/source/xld.SUMPRODUCT.html
it has a very comprhensive explanation of the sumproduct function.
print it out
keep it
you will use it again

 

[Pecoflyer]

Have a look at http://www.xldynamic.com/source/xld.SUMPRODUCT.html
it has a very comprhensive explanation of the sumproduct function.
print it out
keep it
you will use it again

And as Bill says, print it out or at least save the page somewhere.
regularly experienced problems with the site ( xld sometimes forgets hi
bills

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Shane Devenshire]

Hi,

We could use more detail, however suppose your dates are in Column A and the
Amounts in column B. Choose Data, Filter, AutoFilter and pick the drop down
in column A. Choose Custom, choose Greater than or equal to from the first
drop down and enter 1/1/09 in the second box, choose Less than or equal to
from the second drop down and enter 2/28/09 in the next box. Click OK.

Select the first blank cell below the Amount column and click the AutoSum
button.

This will give the sum of visible cells only.

 

[Joe@Willscot]

Thank you for responding so far.

The rest of the story: On one worksheet I have my budget for the year per
month. The budget is broken into different catagories,ie parts, minor and
major, service vehicles, gas and parts, pay, over time. The next worksheet I
have a purchase tracking page, that I log in all of my purchases or kind of
like a register with check numbers, vendors, amounts, date and this is for
the entire year. So the goal was to get the budget work sheet to show what
was spent for the month.
What I have so far is:
SUMIF(B:B,">1/1/2009",D) which works but I can not get it to work when I
put in <1/31/2009