hi all,

i have created (or designed) an excel doc that tracks purchasing for
my projects. what i am trying to do is track how much is spent per
month

in one tab, i have all purchases consolidated .. which cotain the
amount of a PO and the date of which was purchased

Purchase Record tab
Column = PO Value (range F6:F18)
Column = Date Purchased (range G6:G18)

on a next tab, i am trying to identify how much total spend there was
per month using the tab above

Spend Calendar tab (where the issue is)
i have a start date .. say 01/07/2007 (B5)
Row = month number (range C6:N6) eg, 1-12 (for the months of the year)
couple of rows down is where i am trying to use SUMPRODUCT..
=SUMPRODUCT((INT(MONTH('Purchase Record'!$G$6:$G
$18)=INT(C7))*('Purchase Record'!$F$6:$F$7)))

i recieve an #N/A when there is no data within the Purchase record
cell's.

is there a way to ignore all empty rows and move on to the next so it
can calculate?

i have put the worksheet on a website so you guys can see what i am
talking about

http://dev1.replayfunctionsband.net...._Template1.zip

Cheers