With Excel 2003, you need SUMPRODUCT.

For example:

=SUMPRODUCT(--($I$8:$I$46="DIRECT"),--($L$8:$L$46=F$48),--($E$8:$E$46))


Regards