I tried this with blank rows and all was well.
The error N/A suggest something that should be a number is not
Are they truly blank rows?

By the way do not use full column references such as
SUMPRODUCT(--(B:B="North")
unless you have Excel 2007

If you want to send me a file I would be happy to check it for you. (remove
TRUENORTH. from my email address)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message
...
Thanks for your help! Thanks works, but I have one followup
question. With my data I don't know how many rows of data I am going
to have, but I would like to include it up to at least 5000 rows. The
problem is that when I include the blank rows I just get N/A
returned. How can I include the extra rows in my formula, but exclude
them from the calculation if they are blank?