Formula Calculation

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I have a budget spreadsheet named Budget and after that I
have several sheets with each cost code associated with
my budget. I list all the invoices I received and post
them to the correct cost code worksheet. I am trying to
calculate a formula on my "Budget" worksheet that will
Sum the amount of invoices posted on my cost code
worksheet if it meets my date criteria. I am having a
problem with the formula figuring in the date criteria.

Example...
On worksheet "009308" I have the invoice date(A1),
description (A2), and amount (A3). On my "Budget"
worksheet I have Cost Code # (A1). I would like to
calculate a formula for that cost code on my "Budget"
worksheet to sum all the invoices on worksheet "009308"
that fall between 4/1/04 and 4/30/04.
 
If you have:
Invoice Date Description Amount
15/03/2004 a 1
01/04/2004 b 2
10/04/2004 c 3
30/04/2004 d 4
01/05/2004 e 5

Then you could use:
=SUMIF(A2:A6,">31/03/2004",C2:C6)-SUMIF(A2:A6,">30/04/2004",C2:C6)

You can always make it more flexible by referencing date parameters
named ranges and the such like
 
When I put in the formula on my "Budget" worksheet to
bring the info over from my "009208" sheet it brings over
all the amounts because the first formula sees everything
3/31/04 and the second formula sees everything <
Click to expand...
4/30/04. I only want the invoice amounts in between
those 2 dates but I can not figure out the right forumla
to put in to only give me the #'s in between those two
dates.

Thank you for the suggestion...you have gotten me half
way there. Just missing one piece.
 
Back
Top