Wednesday, November 19, 2008

hurray for arrays

{=SUM((Data!$E$692:$E$15000=$A36)*(Data!$B$692:$B$15000=$B$3)*
(Data!$C$692:$C$15000=E$3)*Data!$G$692:$G$15000))}

No comments: