I want to do a sumproduct calculation, but it won't work because one
of the columns of data has formulas in it as well as blank rows.

I took the formulas out and just used the data and it worked, but with
the formulas in there I get an error message.

Is there any way do this? If you need more info, let me know.

Thanks.