View Single Post
  #1   Report Post  
carl
 
Posts: n/a
Default Modifying an Array Formula

I use the following array formula. I wanted to adapt it to count (vs sum). Is
it possible ??

=SUM(IF((Sheet2!$A$2:$A$20000=Sheet1!$E3)*(Sheet2! $J$2:$J$20000=Sheet1!$D$3);Sheet2!$I$2:$I$20000))

Thank you in advance.