Need a little help folks
Have a spreadsheet, looks a little something like this:
Column A Column B
Award Date Task Order Value
6/30/07 $5,156
8/25/07 $43,149
10/12/07 $1,324
04/15/08 $6,993
10/09/08 $34,344
Government Fiscal Year begins on the first of October and ends last day of September. I’m trying to SUM Task Order Values between the dates of 10/01/2007 and 9/30/2008, essentially FY08 task order value. Getting the feeling that I cannot use the SUMIF function, though I used it to SUM FY09 task order value:
=SUMIF(I3:I300,”>”&DATE(2008,9,30),N3:N300)
So how about using multiple criteria to SUM FY08 data, any ideas?
Bookmarks