Hello all,

Ok, I have a simple excel spreadsheet, where I keep track of my
spending on one tab, my income in another and my summary in a thrid.

My problem happens when I try to dynamically calc. avg's for months in
the summary page. For instance, if I want to see how much money I
spent on average per month, or even per day, I draw from the data
entered into the spending page.

Now, the spending page is set up with the following columns:
Date:: Description:: Amount

The problem with this is that I can't predefine a max row # for each
month, since I might have 80 entries in spending in Jan., and only 10
in Feb.

There has to be a way to do this. I've been playing around with it,
and this is as far as I got...

=SUMIF(Income!A2:A700,=AND("=38718","<=38748")),I ncome!C2:C700)

That would be for the month of Jan. (I have calc. the numbers from the
number of days that 1/1/06 and 1/31/06 are from Jan. 1, 1990)

I think my problem lies within my "AND" statement. Is the syntax
correct? Is the semantics correct?? Is there an easier way to do
this??

If my explaination was unclear in any way, just ask me to clairfy, and
I'd be glad to try and do that.

Thanks for anyones help in advance, I appreciate your time!!

- Ian


--
Moomancow3k
------------------------------------------------------------------------
Moomancow3k's Profile: http://www.excelforum.com/member.php...o&userid=30339
View this thread: http://www.excelforum.com/showthread...hreadid=500025