Tuesday, January 6, 2009

so this is the new year

=IF(A9<>2008, SUM(IF(Sheet1!$D$2:$D$4795 = $A9+1, IF(Sheet1!$E$2:$E$4795 = $B9, IF(Sheet1!$Q$2:$Q$4795 = 1, Sheet1!$O$2:$O$4795, 0), 0), 0)), "")

No comments: