I can't tell from your description, what you want to do
could you give an example of what you want to transfer
what problem do the blank rows give you?
can you give an example of the rows 10-61 equation which does work
I assume you have as part of your sumproduct --(A10:A1751<"")
"sahafi" wrote:

I'm pretty familiar with sumproduct and vlookup. This time I have blank rows
in between my data list, and I couldn't get either formula to work.
In sheet1:
Col A has my period data (1-13) and ColB my wks data (1-4), ColM contains my
location number (the same number copied down on 52 rows), on Col AH is my
claculated field that I need to lookup and insert on 'Sheet2'.
I have different projects on sheet1, and each project consists of 52 rows of
data. So in columns (A,B) I will have (1,1), (1,2), (1,3), (1,4), (2,1),
(2,2), (2,3),..(13,4). So columns A & B have the same data for all of my
projects. In the 53rd row of each project, I have the total, then I have 3
blank rows between each project and the other (not completely blank, they do
hold data, that not relevant to this task, so I can't delete them).
The sumproduct work fine If I use the range 10:61, but will not work if I
use the range 10:1751 and that because of the blank rows in between. Is there
a way to ignore these rows, or another formula that will lookup the value? I
don't want to enter a formula with different range for each project, and I
don't want to copy the data to another sheet in a list format (it's huge).
Any help is greatly appreciated.

Thanks.
--
If u change the way u look @ things, the things u look at change.