I`ve spent a few hours making this formel work for 2007. This formel works
for 2006, and I cant figure out why its giving me a hard time. Is it the
formel or could it be the worksheet?

=COUNT(IF(Data!$B$2:$B$65536=Statistikk!B$2;IF(Dat a!$G$2:$H$655360;IF(Data!$F$2:$F$65536=$A3;IF(YEA R(INT(Data!$I$2:$I$65536))=2007;IF(INT(Data!$E$2:$ E$65536)<=INT(Data!$I$2:$I$65536);Data!$G$2:$H$655 36))))))

Data in B column = name of saleperson
Data in G column = Sale amount
Data in F column = weeknumber
Data in I column = Sale date
Data in E column = Date of contact from saleperson
Data in G/H column = Sale amount