Thread
:
Modifying an Array Formula
View Single Post
#
1
carl
Posts: n/a
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.
Reply With Quote