View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yshridhar yshridhar is offline
external usenet poster
 
Posts: 229
Default 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