sumif array function
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
|