Many Thanks to you Mr. Peo Sjoblom. Not only uour suggestion solved my
problem but also it reduced some of my very long formulae to fit into the
formula box. However sumproduct is not working with my data. I don't know
it may be due to my data. Any suggestions
My Sincere Thanks
Sridhar

"Peo Sjoblom" wrote:

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