You don't need to array enter if you use

=SUMPRODUCT((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$ 3000="School")*(exp!$G$3:$G$3000="cash")*exp!$L$3: $L$3000)


otherwise

=SUM(IF((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000))


--

Regards,

Peo Sjoblom

"yshridhar" wrote in message
...
Can any one suggest me the modification for the formula please?

=SUM(IF((exp!$C$3:$C$3000={4,5})*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000))

In place of {4,5} can i give cell address say A1,B1. Then how the formula
looks like?
Sincere thanks to all
Sridhar