Hi,
I am using the following formula:
=(SUMPRODUCT((Sample!$A$3:$A$1055>=Master!$A$2)*(Historikk!$A$3:$A$1055<=Master!$B$2)*(Sample!$BP$3:$BP$1055)))/1000000
It gives me the sum of values in Sample!, defined my date range in Master!
I have values in 1055 rows in Sample now, and the formula works well.
However; new rows are added daily, so i tried to use this formula
=(SUMPRODUCT((Sample!$A$3:$A$1200>=Master!$A$2)*(Historikk!$A$3:$A$1200<=Master!$B$2)*(Sample!$BP$3:$BP$1200)))/1000000
Now the formula breaks down, #N/A (after changing 1055 to 1200)
Any ideas why this happens or what I can to about it?
Would really appreciate any advice
Gnoke
Bookmarks